Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
bssubibe
Starting Member
1 Post |
Posted - 2008-03-18 : 17:29:40
|
I have an already published application running several MS SQL Server 2000 Reporting Services report.I need a way to find from either the reporting services log or the application server (IIS) logs or windows logto know the frequency of each report being used.Based on this info, the business needs to know which reports are being used and to what extend?How can I acheive this?I have already got the IIS logs and it did not give the required info.I have looked into the Reporting Services logs but it does not provide the info either.Any help is appreciated |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-18 : 17:58:14
|
Try this:SELECT ex.UserName, ex.Format, ex.TimeStart, cat.Name, ex.Parameters, CONVERT(nvarchar(10), ex.TimeStart, 101) AS rundateFROM ExecutionLog AS ex INNER JOINCatalog AS cat ON ex.ReportID = cat.ItemIDORDER BY ex.TimeStart DESCon ReportServer database |
|
|
|
|
|