SSRS: Query to Generate Subscription List

To get subscription list in a report server, we can use query below:
SELECT
     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