Who's running reports in SSRS 2005

[codecomm]

We are trying to see if it's possible to see which users are running what reports.

When users hit a report, they have to enter their WIN credentials.

We do have the default switch is 3:

<!-- 1 = error, 2 = warning, 3 = info, 4 = verbose -->

<add name="DefaultTraceSwitch" value="3" />

...so we're getting the full log, and I see what reports are getting run, but wanted to see if there's a way to see who's running them.

Thanks!

 

[SgtJarrow]

I originally downloaded this pack from somewhere else (don't remember where, but I think it was in SQLMag), but it now seems to be a CodeProject...

http://www.codeplex.com/MSFTRSProdS...Management Sample Reports&referringTitle=Home

It has everything you are asking and more.....Lots of useful data.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer

 

[SgtJarrow]

Here's the original location I used (finally found it)

http://msdn.microsoft.com/en-us/library/aa964131.aspx

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB.NET Programmer

 

[xlbo]

Not followed the links but simply query a copy of the Execution Log table in teh ReportServer database - it records which user rand which report when, with what parameters and rendered into what format...

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

 

[codecomm]

hey all!

Thanks for the threads...here's what I used:

SELECT cat.Name AS ReportName, cat.Description AS ReportDescription, cat.CreationDate, cat.ModifiedDate, ex.UserName, ex.Format, ex.TimeStart,
ex.Parameters
FROM ExecutionLog AS ex RIGHT OUTER JOIN
Catalog AS cat ON ex.ReportID = cat.ItemID
WHERE (cat.Type = 2) AND (ex.RequestType = 1) OR
(cat.Type = 2) AND (ex.RequestType = 0) AND (ex.Format = 'HTML4.0')