Author Topic: How to find all Query definitions?  (Read 290 times)

Offline FerdH4

  • Full Member
  • ***
  • Join Date: Sep 2017
  • Posts: 25
  • Forum Citizenship: +0/-0
How to find all Query definitions?
« 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.
« Last Edit: 04 Apr 2019 05:32:44 am by FerdH4 »

Offline erikc

  • Full Member
  • ***
  • Join Date: Oct 2018
  • Posts: 8
  • Forum Citizenship: +0/-0
Re: How to find all Query definitions?
« Reply #1 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.

Offline FerdH4

  • Full Member
  • ***
  • Join Date: Sep 2017
  • Posts: 25
  • Forum Citizenship: +0/-0
Re: How to find all Query definitions?
« Reply #2 on: 04 Apr 2019 05:33:46 am »
Thank you Erikc for the direction.
« Last Edit: 04 Apr 2019 05:36:16 am by FerdH4 »

 



       
Twittear