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 |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-05-13 : 11:34:56
|
| All,I would like a report to display the number of users and the reports accessed for a certain duration of time[being able to go back and check for previous years as well].I read on the msdn that 60 days worth of report log is kept,and the rest gets wipped off.Any suggestions on how I would be able to get user access list for the past year as well. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-13 : 12:08:47
|
| This will give you a start:-http://weblogs.sqlteam.com/jhermiz/archive/2007/08/14/60285.aspx |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-13 : 12:09:27
|
| This will give you detail information about who accessed and times but maynot fit what you are looking for:SELECTex.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 DESC |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-05-13 : 12:27:45
|
| Thanks Visakh & Sodeep.I have my reports ready and they are getting me back what I want,but the results is only for logs up to 60 days.Since the report mng keeps the log for up to 60 days.My users would like to see data of more than 60 days, example 365 days or last years data.Any suggestions? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-13 : 12:39:22
|
| Only if you uncheck the options in Report manager - not to delete older than 60 days.Otherwise not possiblehttp://www.mssqltips.com/tip.asp?tip=1114 |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-05-13 : 13:28:21
|
| Thank You for the link.I got an idea on how to solve my problem now. |
|
|
|
|
|
|
Report on Users accessing reports