Get‑SqlDscRSDatabaseInstallation - dsccommunity/SqlServerDsc GitHub Wiki

Gets the report server installations registered in the database.

Get-SqlDscRSDatabaseInstallation [-Configuration] <Object> 
 [<CommonParameters>]

Gets the Reporting Services installations registered in the report server database by calling the ListReportServersInDatabase method on the MSReportServer_ConfigurationSetting CIM instance.

This command returns information about all report server installations that are configured to use the same report server database, which is useful in scale-out deployment scenarios.

The configuration CIM instance can be obtained using the Get-SqlDscRSConfiguration command and passed via the pipeline.

Get-SqlDscRSConfiguration -InstanceName 'SSRS' | Get-SqlDscRSDatabaseInstallation

Gets all report server installations registered in the database.

$config = Get-SqlDscRSConfiguration -InstanceName 'SSRS'
Get-SqlDscRSDatabaseInstallation -Configuration $config

Gets report server installations using a stored configuration object.

Specifies the MSReportServer_ConfigurationSetting CIM instance for the Reporting Services instance. This can be obtained using the Get-SqlDscRSConfiguration command. This parameter accepts pipeline input.

Type: Object
Parameter Sets: (All)
Aliases:

Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByValue)
Accept wildcard characters: False

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

This command calls the CIM/WMI provider method ListReportServersInDatabase using Invoke-RsCimMethod.

https://docs.microsoft.com/en-us/sql/reporting-services/wmi-provider-library-reference/configurationsetting-method-listreportserversindatabase