Get-SqlDscReportingsServicesConfiguration: New command proposal

[johlju]

Command proposal

Returns an object containing the configuration of the specified Reporting Services instance.

Proposed parameters

Parameter	Mandatory	Data type	Description	Default value	Allowed values
InstanceName	Yes	String	Name of the SQL Server Reporting Services instance to be configured.	SSRS

Special considerations or limitations

Could use the code here:

SqlServerDsc/source/DSCResources/DSC_SqlRS/DSC_SqlRS.psm1

Lines 1008 to 1027 in 026647c

	$instanceNamesRegistryKey = 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\RS'
	if (Get-ItemProperty -Path $instanceNamesRegistryKey -Name $InstanceName -ErrorAction SilentlyContinue)
	{
	$instanceId = (Get-ItemProperty -Path $instanceNamesRegistryKey -Name $InstanceName).$InstanceName
	if (Test-Path -Path "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$instanceId\MSSQLServer\CurrentVersion")
	{
	# SQL Server 2017 and 2019 SSRS stores current SQL Server version to a different Registry path.
	$sqlVersion = [int]((Get-ItemProperty -Path "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$InstanceId\MSSQLServer\CurrentVersion" -Name 'CurrentVersion').CurrentVersion).Split('.')[0]
	}
	else
	{
	$sqlVersion = [int]((Get-ItemProperty -Path "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$instanceId\Setup" -Name 'Version').Version).Split('.')[0]
	}
	$reportingServicesConfiguration = Get-CimInstance -ClassName MSReportServer_ConfigurationSetting -Namespace "root\Microsoft\SQLServer\ReportServer\RS_$InstanceName\v$sqlVersion\Admin"
	$reportingServicesConfiguration = $reportingServicesConfiguration | Where-Object -FilterScript {
	$_.InstanceName -eq $InstanceName
	}