Get-SqlDscRSConfiguration: Support enumerating all instances

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 #2348, which proposed a separate command that included this functionality

Start with the Get-SqlDscRSConfiguration command and compare its current InstanceName handling with Get-SqlDscRSSetupConfiguration. Verify behavior with and without InstanceName, including multiple installed instances, and confirm that the existing specific-instance behavior remains unchanged.