SSRS: How many reports have been sent out within 24hrs

174 views Asked by At

I have a project that needs to list the reports that have been sent out for the last 24 hours via subscription. Is there a way to do this? Thanks in advance.

For example 10 subscriptions were scheduled today but only 8 were successfully sent.

1

There are 1 answers

0
SAS On

This will give you the list, assuming you are using the name ssrs_dba for your SSRS-database:

 SELECT el.UserName, c.name, el.Parameters, el.TimeStart, el.TimeEnd, el.TimeRendering, el.TimeProcessing, el.TimeDataRetrieval, el.Status, el.Format
 FROM ssrs_dba..Catalog c
 INNER JOIN ssrs_dba..ExecutionLog el ON c.ItemID = el.ReportID
 WHERE el.TimeStart > DATEADD(HOUR, -24, GETDATE())
 ORDER BY el.TimeStart DESC