Viewing last run of SSRS report on SharePoint server

Question

Is there a way to view report usage of SSRS reports that have been built using SharePoint server? I need to get a list of last run times for reports for last 7 days.

Answer 1

Yes, you can use the SSRS ExecutionLog2 table to view the usage statistics of your SSRS reports. This table contains information about each report execution, including the report name, user, start time, and end time.

Here's how you can get a list of last run times for reports for the last 7 days:

Open SQL Server Management Studio and connect to the SQL Server instance that hosts your SharePoint database.

1. Open a new query window and execute the following query to select the report name, user, start time, and end time for each report execution in the last 7 days:

SELECT ReportPath, UserName, TimeStart, TimeEnd FROM ExecutionLog2 WHERE TimeStart >= DATEADD(DAY, -7, GETUTCDATE())

This query selects all rows from the ExecutionLog2 table where the TimeStart column is within the last 7 days.

You can export the query results to Excel or another format to view them more easily.

Note that the ExecutionLog2 table only contains information about report executions that have been logged. If report logging is not enabled, or if the log retention period has expired, you may not be able to retrieve usage statistics for older reports.