08 October 2014

SSRS: Query to Generate Subscription List

To get subscription list in a report server, we can use query below:
     ReportName = c.[Name],
     IDSchedule = rs.scheduleId,
     ScheduleType = s.EventType,
     [Description] = ss.[Description],
     LastStatus = ss.LastStatus,
     LastRun = s.LastRunTime,
     UserName = u.UserName   
FROM ReportSchedule rs
     JOIN Catalog c ON c.ItemID = rs.ReportID
     JOIN Schedule s ON s.scheduleID = rs.scheduleID
     JOIN Subscriptions ss ON ss.subscriptionid = rs.subscriptionid
     JOIN Users u ON u.userid = ss.ownerid

Using database: ReportServer
Connect using Microsoft SQL Server Management Studio to Database Server that used as Report Server

Click here if you like this article.

Related Article:

  1. Installing Business Intelligence SQL Server 2005
  2. Creating Report with SQL Server Reporting (Wizard)
  3. Creating Report with SQL Server Reporting (without wizard) | Part 1
  4. Creating Report with SQL Server Reporting (without wizard) | Part 2
  5. Design Layout Report
  6. Creating Parameter for Filtering
  7. Stored Procedure as Report Data Source
  8. Parameter Data List from Database Query
  9. Creating Report Group
  10. Create Sequence Number Using RowNumber Function
  11. Uploading Report FIle (.rdl) to Report Server
  12. Remove Report Page Break/Page Break 
  13. Query to Generate Subscription List 
  14. Direct Printing to Printer