info@techdevops.com | 437-991-3573 | Data Tier Services
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server, Clusters, Always On, Migrations, Performance, & Cloud



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