Get‑SqlDscRSUrl - dsccommunity/SqlServerDsc GitHub Wiki

Gets the Report Server URLs for a SQL Server Reporting Services instance.

Get-SqlDscRSUrl [-SetupConfiguration] <Object> [<CommonParameters>]

Gets the Report Server URLs for SQL Server Reporting Services or Power BI Report Server by invoking the GetReportServerUrls CIM method on the MSReportServer_Instance CIM class. This returns the URLs for all configured Reporting Services applications (such as ReportServerWebService and ReportServerWebApp).

The setup configuration can be obtained using Get-SqlDscRSSetupConfiguration and passed via the pipeline.

Get-SqlDscRSSetupConfiguration -InstanceName 'SSRS' | Get-SqlDscRSUrl

Gets the Report Server URLs for the Reporting Services instance 'SSRS'.

Get-SqlDscRSSetupConfiguration | Get-SqlDscRSUrl

Gets the Report Server URLs for all Reporting Services instances.

$urls = Get-SqlDscRSSetupConfiguration -InstanceName 'SSRS' | Get-SqlDscRSUrl
$urls | Where-Object -FilterScript { $_.ApplicationName -eq 'ReportServerWebService' }

Gets only the ReportServerWebService URLs for the instance 'SSRS'.

Specifies the setup configuration object for the Reporting Services instance. This can be obtained using Get-SqlDscRSSetupConfiguration. 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.

The Reporting Services instance must have URLs configured via Set-SqlDscRSUrlReservation before URLs will be returned by this command.

https://learn.microsoft.com/en-us/sql/reporting-services/wmi-provider-library-reference/msreportserver-instance-methods-getreportserverurls