Get‑SqlDscRSServiceAccount - dsccommunity/SqlServerDsc GitHub Wiki

SYNOPSIS

Gets the service account for SQL Server Reporting Services.

SYNTAX

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

DESCRIPTION

Gets the Windows service account for SQL Server Reporting Services or Power BI Report Server from the MSReportServer_ConfigurationSetting CIM instance.

This command returns the current service account name that is being used by the Reporting Services Windows service.

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-SqlDscRSServiceAccount

Gets the service account for the Reporting Services instance 'SSRS'.

EXAMPLE 2

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

Gets the service account using a stored configuration object.

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.String

Returns the service account name.

NOTES

This is a convenience wrapper around accessing the WindowsServiceIdentityActual property of the configuration CIM instance.

RELATED LINKS

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

⚠️ **GitHub.com Fallback** ⚠️