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
|
|
|
|
|
|