August 18, 2010 at 9:58 am
Hi
I'm trying to do a clean up excercise on the rather large number of reports. My first step is to remove all reports that haven't been used in over 6 months. I thought this would be easy to do just by looking on Reportserver..ExecutionLog to see when a report was last run. However it seems this table only goes back about 2 months.
Firstly is there something that deletes data from the ExecutionLog table? Secondly is there somewhere else I can look to see when a report was last run?
Thanks
August 18, 2010 at 10:09 am
From my experience cleanup is often a bit of a waste of time (unless done right after dev). However here's the way to keep your history for longer :
SSMS
Connect to reportserver (not database engine)
properties of the server
logging
uncheck remove entries older than...
As for method, I'd create a new folder where nobody has access and move the reports there. Then wait to see for complaints or bugs (keep in mind that some users will not complain and start being pissed about your work and spread the word around and even use that as an excuse to not do their work).
It works but it creates workload that is not there at the moment.
The only valid reason I see to do this is if you have to modify all reports that access X tables and you need to lighten the workload from 100s to a lot less...
Also keep in mind that some reports are used only yearly or even less so you'll probably need to wait another 10 months to see what needs to be flushed.
P.S. Search for employees who've moved on who have a report folder... those are probably save to flush after you've backed them up.
August 19, 2010 at 2:37 am
Thank you for your response. You make some very valid points.
The aim of the clean-up is to reduce the request of new reports by orgainising what is already there & giving clear descriptions of what each report does and remove badly performing and unused reports. The idea is the business can then work with what they have.
Thanks
Sarah
August 19, 2010 at 5:06 am
Well then that should be your best bet. List all the reports, make some "help" file and present to all users at once. Then at the end of every presentation you can ask wether or not they want to keep it. If nbody raises their hand to keep it then you can safely move to an "obsolete" folder just for when they change their mind.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply