Need script to get historical data on Windows users connected to Report Server and most-viewed reports

  • Is this historical info kept somewhere in the ReportServer database?

    I need to get a list of Windows users that have connected recently to the report server, as well as the most-viewed reports.

    Is there a way I can get this info?

    Thanks,

    Marios

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • I found these two links, which seem very relevant to my question:

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

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

    If anyone has any additional info, it would be appreciated.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply