How to check on your SSRS Execution Log History using a SQL Script

Using this sql script I’m able to run it and get a quick list of what SSRS reports just ran. The script also gives me details like the username, format of report, the report name and what parameters we’re used in creating the SSRS report.

It’s a pretty handy SQL script for seeing data quickly. I also found this online and modified it for my use but if anyone knows of the originator of this, let me know.

Happy to give credit for all these. I found lots of scripts like these online and because SSRS isn’t super popular, maybe that’s why I can’t find them as easily anymore.

SELECT  ex.UserName ,
        ex.Format ,
        ex.TimeStart ,
        cat.Name ,
        ex.Parameters ,
        CONVERT(NVARCHAR(10), ex.TimeStart, 101) AS rundate
FROM    ExecutionLog AS ex ,
        Catalog AS cat
WHERE   ex.ReportID = cat.ItemID
ORDER BY ex.TimeStart DESC;

SQL script to show you a list of your SSRS subscriptions

At work we use SQL Server Reporting Services (SSRS) for our reporting needs. I like to have a few SQL Scripts to help me keep track of our subscriptions, when they ran and check on any errors.

Here’s a couple of SQL Scripts that I use when needed and I don’t have the website where I found these but if you know where they we’re originally posted, let me know so I can give credit where credit is due.

LIST OF SSRS SUBSCRIPTIONS

SELECT SubscriptionID ,
d.LastStatus ,
e.Name ,
e.Path ,
d.DeliveryExtension ,
d.LastRunTime ,
d.ExtensionSettings
FROM Subscriptions d
JOIN ReportServer.dbo.Catalog e ON d.Report_OID = e.ItemID

LIST OF SSRS SUBSCRIPTIONS ORDER BY MOST RECENTLY RAN REPORT

SELECT SubscriptionID ,
d.LastStatus ,
e.Name ,
e.Path ,
d.DeliveryExtension ,
d.LastRunTime ,
d.ExtensionSettings
FROM Subscriptions d
JOIN ReportServer.dbo.Catalog e ON d.Report_OID = e.ItemID
ORDER BY d.LastRunTime DESC;

LIST OF SSRS SUBSCRIPTIONS SETUP FOR FILESHARE DELIVERY

SELECT  SubscriptionID ,
        d.LastStatus ,
        e.Name ,
        e.Path ,
        d.DeliveryExtension ,
        d.LastRunTime ,
        d.ExtensionSettings
FROM    Subscriptions d
        JOIN ReportServer.dbo.Catalog e ON d.Report_OID = e.ItemID
WHERE DeliveryExtension = 'Report Server FileShare'

LIST OF SSRS SUBSCRIPTIONS SETUP FOR EMAIL DELIVERY

SELECT  SubscriptionID ,
        d.LastStatus ,
        e.Name ,
        e.Path ,
        d.DeliveryExtension ,
        d.LastRunTime ,
        d.ExtensionSettings
FROM    Subscriptions d
        JOIN ReportServer.dbo.Catalog e ON d.Report_OID = e.ItemID
WHERE DeliveryExtension = 'Report Server Email'