Get‑SqlDscRSUrl

SYNOPSIS

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

SYNTAX

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

DESCRIPTION

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.

EXAMPLES

EXAMPLE 1

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

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

EXAMPLE 2

Get-SqlDscRSSetupConfiguration | Get-SqlDscRSUrl

Gets the Report Server URLs for all Reporting Services instances.

EXAMPLE 3

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

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

PARAMETERS

-SetupConfiguration

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

CommonParameters

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

INPUTS

System.Object

Accepts setup configuration objects from Get-SqlDscRSSetupConfiguration

via pipeline.

OUTPUTS

[ReportServerUri[]]

Returns an array of ReportServerUri objects containing the instance name,

application name, and URL. Returns $null if no URLs are configured.

NOTES

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

RELATED LINKS

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