Resources can be scarce in an IBM Cognos environment. A lack of resources can quickly lead to performance issues in the environment causing problems for the end users and administrators. When performance issues do start creeping up, a common question administrators will ask is, “How can we clean up the Content Store to improve performance?” One piece of low-hanging fruit is to remove or disable all scheduled reports that have no recipients. It makes little sense to have these reports running when no one in the company is receiving or viewing them. We recently published a Knowledgebase article that details how you can leverage MetaManager’s™ Script Runner module to generate a list of all scheduled reports with no recipients. The article contains a sample script you can use as well as instructions on using the script. You can view the article here.
If this is your first time hearing about our Script Runner module you can find more information here. Script runner lets you automate boring, repetitive task, or even complicated, cumbersome tasks in Cognos. It’s like a having a custom easy-button for your Cognos environment!