SCCM Reporting Details
Question
Is there a way to find all SCCM SSRS scheduled reports details such as (Report Name, schedule time, mail IDs configured, etc.)..
Pls help as we have many reports scheduled and manual work will take very long time..
solved
0
Configuration Manager
9 months
2 Answers
163 views
Beginner 0
Answers ( 2 )
I don’t have answer to this question.
My tip would be check SQL Reporting services and DB to get this details
Some hints from Steve https://stevethompsonmvp.wordpress.com/2014/10/10/how-to-list-ssrs-report-permissions/
Below Powershell worked like Charm :), Thanks to Microsoft Docs – > https://docs.microsoft.com/en-us/sql/reporting-services/subscriptions/manage-subscription-owners-and-run-subscription-powershell?view=sql-server-ver15
I have modified the script to suit my requirement:- (Hopefully it will help others too)
———————
$ReportServer = “”
$Site = “/”
$ReportServerUri = “http://$($ReportServer)/reportserver/ReportService2010.asmx?wsdl”
$rs2010 += New-WebServiceProxy -Uri $ReportServerUri -Namespace SSRS.ReportingService2010 -UseDefaultCredential ;
$subscriptions += $rs2010.ListSubscriptions($site); # use “/” for default native mode site
Write-Host ” ”
Write-Host “—– $server’s Subscriptions: ”
$subscriptions |Select Report,Status,Owner
———————–