June 2, 2009 at 12:40 pm
As we created new reports, we don't always remove the old reports, or are not told to remove them.
I would like to find old SSRS reports that haven't been used in say over 6 months to a year.
I have a StartTime and EndTime in my columns.
June 3, 2009 at 7:55 am
By default the ReportServer only keeps Execution History for 60 days. I found this with this query:
select
Value
from
ConfigurationInfo
where
[Name] = 'ExecutionLogDaysKept'
So unless you have changed that value you can only know back 60 days by querying the ExecutionLog table joined to the Catalog table.
There may be another way to tell report useage, but I don't know what it would be.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 15, 2009 at 7:09 am
If you have subscriptions, then you can see them on Schedule ReportServerDB table.
Eralper
January 30, 2010 at 3:27 pm
Dakotah (6/2/2009)
I would like to find old SSRS reports that haven't been used in say over 6 months to a year.I have a StartTime and EndTime in my columns.
Hi Dakotah. You have that information but only within last 60 days as Jack said.
Take a deep look at my article:
http://www.bidn.com/articles/reporting-services/85/ssrs-information-about-reports-ran]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply