COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: oscarca on 29 Apr 2019 09:47:08 AM

Title: Bulk delete reports not being used
Post by: oscarca on 29 Apr 2019 09:47:08 AM
Hello Community,

I am cleaning the Cognos 10.2.2 Environment from unused reports and looking for tips and ideas how to do this most efficiently. Are there any scripts you can run towards the content store database to find and delete reports based on timestamp being used ? 

All tips are greatly apprieciated.
best reagrds,
Oscar
Title: Re: Bulk delete reports not being used
Post by: saumil287 on 28 May 2019 06:37:45 AM
Hi,

There is package and model that get shipped with IBM cognos,
known as audit package,

It tells you the details of report execution, whether it was executed in last days, months or years. accordingly you can get the details of the reports and package that are not used and can delete the same. You need to check with the person who installed cognos
Title: Re: Bulk delete reports not being used
Post by: oscarca on 28 May 2019 07:41:09 AM
Hey Saumil,

I know this, but you still have to delete the reports manually. I was thinking if there was somekind of way to automate this process, so that the reports that are not being used are deleted automatically once you run the script.