Report about my reports

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

Answer 1

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.

Answer 2

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