CMS question - Designer Reports Last Time Used

[wenparkhay]

Over many years, we've seemed to have accumulated 100's of designer reports. Is there a way to run a Unix command to see if or when these designer reports were last accessed/used? I have saved all the designer reports and did think about removing some to see if anyone complained...but this is last resort. Not sure if I want to email all 400+ supervisors and ask them if they use any designer reports and if so, which ones. If anyone has any suggestions, I would love to hear them. Thanks.

 

[phoneguy55]

Curious why you care how many reports are on the server.

 

[Stinney]

I've never been able to determine this. At my old company we had an engineer that made 100s of "Test" reports, we couldn't tell if anyone was using them.

You don't have to remove them, you can just restrict them to only be run by administrative users by editing the report to only be seen by you. That way if someone complains you can just open it back to be viewed by all. Restrict them for 90, 120, 180 days, whatever you want, then start removing them. If you want to be extra sure, copy it out to a PC location and save them for later, you can reload them if someone complains.



- Stinney
"Scire ubi aliquid invenire possis, ea demum maxima pars eruditionis est"

"To know where to find anything is, after all, the greatest part of education"

 

[Stinney]

OK, looks like you can figure this out, but it's not pretty.

Designer files are located here: /cms/cow/reports/designer But the file names are just numbers, probably created in the order they were created.

In my system it looks like CMS might do some sort of access check and every file has a time stamp of last accessed as of today at 5am. But if I run a designer report it changes the accessed time. If you run each report and then do a list of the files using: ls -lu | more you will be able to match up the file name in CMS with the name of the report in CMS Supervisor.

You could write a cron job that woule export this to a file every night, then after 90, 120, 180 days, check the list and backup and remove any that haven't been accessed.

- Stinney
"Scire ubi aliquid invenire possis, ea demum maxima pars eruditionis est"

"To know where to find anything is, after all, the greatest part of education"