Post reply

Creating A report to show who has been running reports RS2000

  • August 6, 2006 at 7:57 pm

    #367058

    Hi

    Can anyone tell me if it is possible to create a report that will give me a break down on who has been running reports.

    I have looked at the sql tables. The main 2 tables seem to be the Catalog and Executionlog. Both give me information I want but I can't see an id that I can use to link the 2 tables together.

    If you know of a way for me to get this data, please tell.

    Tracy Avis

  • August 9, 2006 at 1:23 am

    #653985

    Hi, there is a PK-FK link, its just not the same column name in both tables. I am on sick leave at the moment and cant get to a SQL Server, from memory i think its ReportID and ItemID???

    anyway HTH

    J

  • August 9, 2006 at 4:17 am

    #654012

    I wouldn't recommend querying the reportserver tables directly as these are used to control your report executions.  However, reporting services does ship with sample reports for monitoring your reports.  Details and sample reports can be found at http://msdn2.microsoft.com/en-us/library/ms161561.aspx

  • August 9, 2006 at 4:25 am

    #654016

    David, what tables do these reports query? what problem can running a select query against these tables cause?

  • August 9, 2006 at 9:06 am

    #654103

    RS has a DTS package called RSExecutionLog_update which enables data to be extracted from the ReportServer db into more user friendly format. This package comes on the install disc.

    When this is all set up all the execution data is copied to a second database called RSEXecutionLog and a number of reports can be installed on RS to get the information you are after.

    Look at this link for full details: http://www.databasejournal.com/features/mssql/article.php/10894_3459461_1

     

     

  • September 5, 2006 at 9:36 pm

    #658691

    Hi Richard

    Thanks for this, only now just getting around to setting it up, however having problems when trying to execute the DTS package.

    Having an issue when it comes to Set Con Dynamic Properties task - saying it can't read the file. This is when trying to execute package from my machine as to doing it on the server.

    Second problem when on the server we managed to get past this bit but it then errored out when trying to perform the updates. It was coming back with not enough storage space to complete this operation. There is plenty of room on the server, so that it not the problem.

    Can you help

    Cheers

    Tracy

     

Viewing 6 posts - 1 through 5 (of 5 total)

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