Report Usage Audit 1

[dhulbert]

Is it possible to report on the uasage of reports.
I'm looking to report on the reports a uaser has run and which users have run specific reports

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[xlbo]

You can quesy the reportserver database which will tell you which user id ran which report with any passed parameters....

The 2 most useful tables are 'Catalog' & 'Execution_Log'

This is the basis of a query that I use to do a similar thing:

SELECT dbo_Catalog.Name, right(dbo_ExecutionLog.UserName,len(dbo_ExecutionLog.UserName)-7) as UserID, dbo_Catalog.ItemID, Format([TimeStart],""dd/mm/yyyy"") AS DateRun, Count(dbo_ExecutionLog.TimeStart) AS Runs 
FROM dbo_Catalog INNER JOIN dbo_ExecutionLog ON dbo_Catalog.ItemID = dbo_ExecutionLog.ReportID

Not sure if it is default setting but data seems to be kept for a rolling 12 weeks so if you want any long term trends, you will have to hive the data off to a seperate table

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[dhulbert]

Great Cheers.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)