Get‑SqlDscRSSslCertificate

SYNOPSIS

Gets the available SSL certificates for SQL Server Reporting Services.

SYNTAX

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

DESCRIPTION

Gets the SSL certificates available on the machine for use with SQL Server Reporting Services or Power BI Report Server by calling the ListSSLCertificates method on the MSReportServer_ConfigurationSetting CIM instance.

This command returns information about certificates that can be bound to the Reporting Services instance for SSL/TLS connections.

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

EXAMPLES

EXAMPLE 1

Get-SqlDscRSConfiguration -InstanceName 'SSRS' | Get-SqlDscRSSslCertificate

Gets all available SSL certificates for the Reporting Services instance.

EXAMPLE 2

Get-SqlDscRSConfiguration -InstanceName 'PBIRS' | Get-SqlDscRSSslCertificate

Gets all available SSL certificates for Power BI Report Server.

PARAMETERS

-Configuration

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

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

Microsoft.Management.Infrastructure.CimInstance

Accepts MSReportServer_ConfigurationSetting CIM instance via pipeline.

OUTPUTS

System.Management.Automation.PSCustomObject

Returns objects with properties: CertificateName, HostName,

and CertificateHash.

NOTES

This command calls the WMI method ListSSLCertificates. This method does not require an LCID parameter as it simply lists available certificates on the machine.

RELATED LINKS

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