Provides access to a SQL Server Reporting Services installation.


The SSRS provider lets you get, add and delete items from a SQL Server Reporting Services installation. Items are represented as a CatalogItem. All communication to the SSRS system is done over the ReportService2005 web service. A drive must exist in order to get access to the SSRS system. For example, in order to create a drive that provides access to the SSRS system you could execute the following:
$ReportServiceWsdlUrl = "http://localhost:8080/ReportServer/ReportService2005.asmx"
New-PSDrive -Name rs -Root '\' -WebServiceUrl $ReportServiceWsdlUrl -PSProvider ReportingServices

Once the drive has been created, commands can be executed to access the provider.

Navigating the SSRS system

Change to the reports folder on the SSRS system.
Set-Location rs:\reports

Getting SSRS items

Get all items under the root:
Get-ChildItem rs:\

Get items under the reports folder:
Get-ChildItem rs:\reports

Get items that are only of type "DataSource"
Get-ChildItem rs:\ | Where-Object { $_.Type -eq "DataSource" }

Last edited Nov 13, 2009 at 4:38 AM by saadware, version 5


No comments yet.