Sunday, August 15, 2021

Who is running the SSRS reports

In sometimes, we need to see who is using the specific SSRS report or need to understand which report is used frequently or what kind of reports are used for specific user.

The SSRS report history is stored in ReportServer database. The view name is ExecutionLog3.

We can use the following query to fetch the data.


USE ReportServer

SELECT  * FROM ExecutionLog3

ORDER BY TimeStart DESC


We can get the user details on Username column. The username column works only for AX 2012. The username column is not working for D365, because in AX 2012 we can give report permission for specific user, in D365 if user having permission for report then the user can run the report.


No comments :

Post a Comment