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..
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
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..
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
———————–