Viewing last run of SSRS report on SharePoint server

Philip Herman 0 Reputation points

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.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,628 questions
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
8,536 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vahid Ghafarpour 8,235 Reputation points

    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.

    0 comments No comments