COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Upgrading to Cognos Analytics => Topic started by: FerdH4 on 12 Mar 2019 06:54:51 AM

Title: How to find all Query definitions?
Post by: FerdH4 on 12 Mar 2019 06:54:51 AM
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.
Title: Re: How to find all Query definitions?
Post by: erikc on 04 Apr 2019 02:38:15 AM
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.
Title: Re: How to find all Query definitions?
Post by: FerdH4 on 04 Apr 2019 05:33:46 AM
Thank you Erikc for the direction.