Report on Users accessing reports

• Lookup_BI

  SSCrazy

  Points: 2964

  More actions

  May 13, 2008 at 9:36 am

  #187668

  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.

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

• Lookup_BI

  SSCrazy

  Points: 2964

  More actions

  May 13, 2008 at 11:29 am

  #814693

  Problem Solved.Got my answer from

  http://www.mssqltips.com/tip.asp?tip=1114

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]