SELECT TOP 1000 [name],
[instancename],
[reportid],
[username],
[requesttype],
[format],
[parameters],
[timestart],
[timeend],
[timedataretrieval],
[timeprocessing],
[timerendering],
[source],
[status],
[bytecount],
[rowcount]
FROM [ReportServer].[dbo].[executionlog]
INNER JOIN [ReportServer].[dbo].[catalog]
ON [reportid] = [itemid]
ORDER BY timestart DESC
--// Unique List
SELECT DISTINCT [name]
FROM [ReportServer].[dbo].[executionlog]
INNER JOIN [ReportServer].[dbo].[catalog]
ON [reportid] = [itemid]
ORDER BY [name] DESC
--// Main Reports
SELECT DISTINCT [name],
[instancename],
[AccessAmount] = Count(NAME)
OVER(
partition BY NAME)
FROM [ReportServer].[dbo].[executionlog]
INNER JOIN [ReportServer].[dbo].[catalog]
ON [reportid] = [itemid]
ORDER BY [accessamount] DESC
--// Main Users by reports
SELECT DISTINCT [name],
[instancename],
[username],
[AccessAmount] = Count(NAME)
OVER(
partition BY NAME, [username])
FROM [ReportServer].[dbo].[executionlog]
INNER JOIN [ReportServer].[dbo].[catalog]
ON [reportid] = [itemid]
ORDER BY 1,
[accessamount] DESC
--// Main Users
SELECT DISTINCT [username],
[AccessAmount] = Count(NAME)
OVER(
partition BY [username])
FROM [ReportServer].[dbo].[executionlog]
INNER JOIN [ReportServer].[dbo].[catalog]
ON [reportid] = [itemid]
ORDER BY [accessamount] DESC
