SSRS Queries for a DBA or Developers to monitor Reporting Server

The Script to Check Reports and Subcriptions with Sorted results per last Run Date SELECT c.Name AS ReportName , rs.ScheduleID AS JOB_NAME , s.[Description] , s.LastStatus , s.LastRunTime FROM ReportServer..[Catalog] c JOIN ReportServer..Subscriptions s ON c.ItemID = s.Report_OID jOIN ReportServer..ReportSchedule rs ON c.ItemID = rs.ReportID AND rs.SubscriptionID = s.SubscriptionID order by 5 To Check Latest…