locked
Report about my reports RRS feed

  • Question

  • I inherited a pretty large reports menu (over 256 reports)

    My task is to create a report that shows details about all my reports.

    It shoujld have:

    Report Name

    Description

    Modified Date

    Date Last Generated

    Last Generated by Employee Name

    Is there anything already exising I could use/modify? If not, how would I start such a project?


    qeqw
    Wednesday, September 2, 2009 4:17 PM

Answers


  • hello

    could try looking at the ExecutionLog table in the reportserver database, has most of what i think your after 

    i know that its not something your ment to do but it will give you the information your after using the query below.

    hope this helps

     


    SELECT     
        C.Name, 
        C.Path, 
        C.Type, 
        C.ModifiedByID,  
        C.ModifiedDate, 
        E.UserName, 
        E.Format, 
        E.TimeStart, 
        E.TimeProcessing, 
        E.TimeRendering, 
        E.Status, 
        U.UserName AS ModifiedBy
    FROM         ExecutionLog AS E INNER JOIN
                          Catalog AS C ON 
    E.ReportID = C.ItemID INNER JOIN
                          Users AS U ON 
    C.CreatedByID = U.UserID 
    AND C.ModifiedByID = U.UserID
    • Proposed as answer by Raymond-Lee Friday, September 4, 2009 1:40 AM
    • Marked as answer by Raymond-Lee Friday, September 11, 2009 3:59 AM
    Friday, September 4, 2009 12:00 AM

All replies

  • you would have to look at what each report in your 256 displays and then create new queries to caculate totals value of what the >256 reports display.
    Wednesday, September 2, 2009 7:02 PM

  • hello

    could try looking at the ExecutionLog table in the reportserver database, has most of what i think your after 

    i know that its not something your ment to do but it will give you the information your after using the query below.

    hope this helps

     


    SELECT     
        C.Name, 
        C.Path, 
        C.Type, 
        C.ModifiedByID,  
        C.ModifiedDate, 
        E.UserName, 
        E.Format, 
        E.TimeStart, 
        E.TimeProcessing, 
        E.TimeRendering, 
        E.Status, 
        U.UserName AS ModifiedBy
    FROM         ExecutionLog AS E INNER JOIN
                          Catalog AS C ON 
    E.ReportID = C.ItemID INNER JOIN
                          Users AS U ON 
    C.CreatedByID = U.UserID 
    AND C.ModifiedByID = U.UserID
    • Proposed as answer by Raymond-Lee Friday, September 4, 2009 1:40 AM
    • Marked as answer by Raymond-Lee Friday, September 11, 2009 3:59 AM
    Friday, September 4, 2009 12:00 AM