Get-SqlDscRSConfiguration: Support enumerating all instances

[johlju]

Problem Statement

Currently, Get-SqlDscRSConfiguration requires the InstanceName parameter to be specified. To enumerate configuration for all Reporting Services instances, users must use a workaround:

Get-SqlDscRSSetupConfiguration | ForEach-Object { Get-SqlDscRSConfiguration -InstanceName $_.InstanceName }

Proposed Enhancement

Make the InstanceName parameter optional. When not specified, the command should return configuration CIM instances for all installed Reporting Services instances.

Expected Behavior

# Get configuration for all instances
Get-SqlDscRSConfiguration

# Get configuration for a specific instance (current behavior)
Get-SqlDscRSConfiguration -InstanceName 'SSRS'

Implementation Notes

• When InstanceName is not specified, call Get-SqlDscRSSetupConfiguration internally to discover all instances
• Return an array of CIM instances when multiple instances exist
• Maintain backward compatibility - existing scripts using -InstanceName should continue to work

Related

• This enhancement was identified while reviewing PR Get-SqlDscRSConfigurationSetting: new public function #2348, which proposed a separate command that included this functionality

[dhruv0206]

@johlju Can I take this ?

[johlju]

Yes your welcome to it :)

[dhruv0206]

@johlju Thanks, I'll start working on it

[johlju]

@dhruv0206 how are you progressing?