How to find Clarity PPM Database Columns within NSQL
search cancel

How to find Clarity PPM Database Columns within NSQL


Article ID: 191126


Updated On:


Clarity PPM On Premise


How do I find all occurrences where a database column is used within an NSQL query and elsewhere within PPM without having to look at each and every Object, Query, Portlet, etc. (i.e., I want to find everywhere within PPM that the database column with specific text is used).


Clarity PPM Application


Here are some tips and tables from the PPM database schema that should help in getting the NSQL query data.

Table contains the NSQL query.

Table contains the base information for the NSQL query (Administration -> Queries).

CMN_LISTOF_VALUES has dynamic lookup ID's and corresponding NSQL query can be found in cmn_nsql_queries using the column sql_text_id.

To find the the table name storing NSQL of dynamic lookups:

CA Tuesday Tip: How to find out where an NSQL query is originating from:

If looking for a deeper analysis or need a more specific query, please use the Broadcom Communities.