T-SQL Script to check Activity Monitor Report of SSRS

use ReportServer
select TimeStart, TimeEnd, TimeDataRetrieval, TimeProcessing, TimeRendering, Status, [rowcount],
from executionlog
join [ReportServer].[dbo].[Catalog] i on i.ItemID=reportid
where datediff(d,timeend,getdate())<100 order by 1 desc go

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.