SSRS Auditing

SQL 2008 R2 SSRS tracks report executions in the “ReportServer” database. Here a few queries that can be used on the “ReportServer” database to do auditing. This may be helpful if you need to collect auditing or reporting statistics. Who is using reports and how regularly? – This query counts the number of distinct executions by…