Hi All,
We have got a typical requirement. Our client want to know how many times each report has been run so far and who ran it and do that moving forward as well.
So, with some research, I got some links to access some information about report statistics which is based on report server DB.
https://blog.jpries.com/2013/08/19/ssrs-usage-reporting-with-ssrs/
https://stevestedman.com/2016/01/ssrs-report-usage-queries/
However, the user that I get from those select statements is the SQL Login user instead of F&O user.
So, I need three things,
1. How do I find which F&O user accessed the report each time?
2. The select statements that were given there were on ReportServerDB. How do I fetch these details into F&O?
3. Here in Dev, I have access to ReportServerDB. What do I do with Prod?
Also, I thought, I would create a table in F&O and populate it from ReportServerDB through SQL batch job at SQL Server. However, I got a question again. Will Microsoft help us to setup a SQL Batch job in Prod as we won't be able to do it on our own?
Regards,
Verma MC
