Access SharePoint Integrated SSRS 2012 configuration from script (SharePoint Object Model)?

Question

I need to extract the SSRS 2012 (SharePoint integrated) configuration parameters using a powershell script. 

The powershell cmdlets do not appear to give access to the configuration values that are available via SSRS UI in Central Admin.

How can I gain access to these configuration values?

Answer 1

I believe I've found the solution.

	$spAss = start-SPAssignment
	$ssrsSA = get-spserviceapplication -assignment $spAss | where {$_.TypeName -eq "SQL Server Reporting Services Service Application"}
	if ($ssrsSA) {
		$centralAdmin = (get-spwebapplication -IncludeCentralAdministration -assignment $spAss| 
			Where {$_.IsAdministrationWebApplication}).Url
		$ssrsProxy = new-webServiceProxy -uri "$centralAdmin/_vti_bin/ReportServer/ReportService2010.asmx" -useDefaultCredential
		$ssrsSystemProperties = $ssrsProxy.GetSystemProperties($nil)
	}
	stop-spAssignment $spAss

Answer 2

Hi,

I've tried using the sample you've given above but can't get the changes to reflect in Central Admin. How did you get any updates to values that you have made to actually commit?

Answer 3

Nevermind! I have figured it out. 

$ssrsSystemProperties[0].value = 567
$ssrsProxy.SetSystemProperties($ssrsSystemProperties[0])