SSRS Audit: All reports executed/not-executed during previous 30 days
'Microsoft does not document or support querying the ReportServer database, but it contans a lot of useful information about SSRS reports. A previous article, Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query, demonstrated how to query the ReportServer.dbo.Catalog to generate live documentation of SSRS reports.
In this article we will query the ReportServer.dbo.ExecutionLog table to determine which reports have been executed in the past month and which have not.
By default, SQL Server only stores 30 days of data in the ReportServer.dbo.ExecutionLog table. For more information on how to configure execution logging see How to Audit Report Execution in SSRS by Peter Avila.
Reports Executed During Past 30 Days: Paste the following query of the ReportServer.dbo.ExecutionLog into a SQL Server Managment Studio query panel...'...
Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt