Usage Tracking

  • Hello -

    I have found several articles online regarding usage statistics for existing reports/users but I am trying to figure out a way to log when a new report has been added to the Report Server. I don't fully understand the ExecutionLog and Catalog tables... maybe the information is being logged but I'm not sure how to query the data.

    It would be very helpful to know what report has been added; when the report was added; and who added the report.

    Thanks in advance!

    Mike

  • Hi Mike,

    something like this?

    use ReportServer

    go

    SELECT u.UserName, c.CreationDate, c.Name, c.[Path]

    FROM dbo.[Catalog] c

    left join dbo.Users u on u.UserID = c.CreatedByID

    Cheers

  • I can definitely use something like this! Thank you!

    Do you know if it's possible to be notified when a new report has been pusblished? Maybe I can go that direction instead of seeing the entire catalog by user.

    Thanks again!

  • No problem!

    Do you need instant notification?

    You could achieve this with a trigger on the table calling database mail. I'd be wary of making changes directly to 'system' tables like this though.

    Another way would be to create a job that returns the results for the last day/hour - whatever frequency works best.

    This would show any items created the previous day: (note this includes folders, datasources etc, not just reports)

    use ReportServer

    go

    SELECT u.UserName, c.CreationDate, c.Name, c.[Path]

    FROM dbo.[Catalog] c

    left join dbo.Users u on u.UserID = c.CreatedByID

    where c.CreationDate >= CAST(CAST(DATEADD(DD, -1, GETDATE()) AS DATE) AS DATETIME)

  • Very helpful! Thank you again!

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

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