Stats on when reports have been run

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin9876 - 22 Aug 2008 15:06 GMT

In SQL 2005 Reports Server is there details of which reports have been
run and when?

Reply to this Message

cmayers - 28 Aug 2008 19:46 GMT

select name, count(name) as NoTimes
FROM Catalog (nolock) INNER JOIN
ExecutionLog (nolock) ON Catalog.ItemID =
ExecutionLog.ReportID
where Executionlog.username <> 'NT AUTHORITY\SYSTEM'
group by catalog.name
order by count(name) desc

Signature

cjm

> In SQL 2005 Reports Server is there details of which reports have been
> run and when?

Reply to this Message

Robin9876 - 29 Aug 2008 15:24 GMT

Thanks that is really useful.

Do you know if there Is there any documentation for the fields in
those tables?

> select name, count(name) as NoTimes
> FROM Catalog (nolock) INNER JOIN
[quoted text clipped - 8 lines]
> > In SQL 2005 Reports Server is there details of which reports have been
> > run and when?

Reply to this Message