March 15, 2013 at 7:50 am
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
March 15, 2013 at 9:15 am
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
March 15, 2013 at 10:57 am
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!
March 15, 2013 at 11:07 am
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)
March 15, 2013 at 11:11 am
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