Post reply

What users are running reports

  • November 9, 2005 at 7:44 pm

    #169730

    Hello!

    I was wondering if there is way to determine from RS systems tables what users are currently executing which reports?

    Thanks,

    Igor

     

  • November 14, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • November 14, 2005 at 1:13 pm

    #603744

    For this you can use 2 tables in ReportServer database, Catalog & ExecutionLog. You can join them by Catalog.ItemID = ExecutionLog.ReportID. In these tables you will find useful information like which user running which report at what time etc.

    Also RS 2000 comes with ExecutionLog Subsystem, that includes script for DB creation and cleanup, DTS package and config file. The purpose of this subsystem is to provide log information. These files are by default located under "..\Microsoft SQL Server\80\Tools\Reporting Services\ExecutionLog" folder. Check that out, it might be helpful.

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

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