Powershell to run Report Builder Reports RDL
MOSS 2007: Client has a library of reports created in Report Builder and SharePoint. These ".RDL" files are stored in specific folders. Are there powershell commands that will allow for this? 1. Given a specific Report Library 2. For each report definitions "RDL" in Library 3. If the report definition last run failed, or it's last successful run is more than X days ago 4. For each subscription inside the RDL 5. Run the subscription Once
October 25th, 2012 9:14am

Hi SC_DOR_JB, To achieve the goal you want, we can use the SQL Server Reporting Service(SSRS) API. Here I would like to show you an example on how to list reports from a special folder: #Define Variables #Enter URI to ReportService2010 end point on Report Server $URI = "http://sql-01/ReportServer/ReportService2010.asmx?wsdl" #Enter Folder path $FolderPath = "/" $wsReportService2010 = New-WebServiceProxy -Uri $URI -UseDefaultCredential -namespace "ReportService2010" $rs = new-object ReportService2010.ReportingService2010 $rs.Credentials = [System.Net.CredentialCache]::DefaultCredentials $items = $rs.ListChildren($FolderPath, $true) foreach($item in $items){ ([ReportService2010.CatalogItem]$item).Name; } For more information on the SSRS API, please see: http://msdn.microsoft.com/en-us/library/ms155398.aspx Thanks, Jinchun ChenJinchun Chen Forum Support Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff AT microsoft.com(Please replace AT with @)
Free Windows Admin Tool Kit Click here and download it now
October 30th, 2012 5:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics