Querying the Report Server Execution Log (SSRS and PBIRS)
'In SQL Server 2008 R2, the Reporting Services execution log table is called dbo.ExecutionLogStorage (whereas in 2000 and 2005, it was called ExecutionLog). This table logs an entry each time the Report Server interacts with a report after it's been deployed to the Report Server.
Execution Log Views
Since Microsoft recommends against querying the Report Server tables directly, it provides 3 standard views in the ReportServer database.
- dbo.ExecutionLog: for backwards compatibility
- dbo.ExecutionLog2: for SQL Server 2008
- dbo.ExecutionLog3: for SQL Server 2008 R2 (same as ExecutionLog2, with 2 fields renamed: ReportPath is now ItemPath, and ReportAction is now ItemAction)'...
https://www.sqlchick.com/entries/2011/2/6/querying-the-report-server-execution-log.html
Trackbacks
Keine Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt