Home ›
ASP.NET Forums » Advanced ASP.NET » SQL Server Reporting Services » Reports usage frequency for all the existing reports on SSRS 2000

Reports usage frequency for all the existing reports on SSRS 2000

Last post 03-19-2008 8:04 AM by Corwin. 1 replies.

Sort Posts:

  • Reports usage frequency for all the existing reports on SSRS 2000

    03-18-2008, 5:13 PM
    • Member
      point Member
    • bssubibe
    • Member since 03-18-2008, 9:09 PM
    • Posts 1

    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 log
    to 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

  • Re: Reports usage frequency for all the existing reports on SSRS 2000

    03-19-2008, 8:04 AM
    Answer
    • Participant
      1,801 point Participant
    • Corwin
    • Member since 11-30-2007, 10:01 AM
    • Ohio
    • Posts 340

    You might want to look at logging it from the database side.  Add another dataset to your report like:

    INSERT INTO LogTable (DescriptionField, TheDate)
    VALUES
    ('Report Ran', sysdate)

    You could add other data like User, entered parameters, etc.  HTH.

    - Corwin
    (My Blog - www.ballhead.com/corwin)
Page 1 of 1 (2 items)
RSS Available

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.