If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to find all Query definitions?

Started by FerdH4, 12 Mar 2019 06:54:51 AM

Previous topic - Next topic

FerdH4

In our v11 system, Query Studio has been purposely disabled so that no one can create any new Query definitions.  However, I have an undetermined number of v10 Query definitions that need to be migrated to Report definitions.  I know the technique for migrating those definitions...if I can find them.

It appears to be that v11's general "Search" function isn't as powerful as v10's which allowed for more advanced search tools/options.  Seems that v11's Search can't help me find just Query definition objects.

Is anyone aware of another technique for how I can find in my v11 system all of the Query definition objects?  Anyone have a helpful SQL statement they might be able to share to do this outside of Cognos if necessary.

Thank you all for the considerations.

erikc

The Cognos AuditExtension for Cognos Analytics can help you with this.
https://developer.ibm.com/tutorials/ibm-cognos-11-audit-extension/

Cognos AuditExtension can read the total Content Store including report specifications.

When you add the Cognos Audit Extension package you can make a specific report based on your Content Store. To make a list of all the Query reports check the "Item Details" table in the "Content Audit" section.

FerdH4

#2
Thank you Erikc for the direction.