November 9, 2005 at 7:44 pm
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
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