info@techdevops.com
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server Operations, Performance, Replication, Cloud & Migrations



SQL Server Reporting Services - Report Usage Stats
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
2018-11-23








T-SQL:


Select
InstanceName,
UPPER(ReportPath) as 'Report',
RequestType,
UserName,
DatePart(Year, TimeStart) as 'Year',
DatePart(Month, TimeStart) as 'Month',
count(*) as 'Total Report Calls'
from ExecutionLog2
group by InstanceName, ReportPath, RequestType, Username, DatePart(Year, TimeStart), DatePart(Month, TimeStart)
order by InstanceName ASC, ReportPath ASC, RequestType ASC, 'Year' ASC, 'Month' ASC