How to find columns on various UIM database tables ?

Article Id: 34722

Status: Published

Updated On: 14-02-2018 08:20

Legacy Id: TEC000003298

Products:

CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) , NIMSOFT PROBES

Issue/Introduction:

Summary:

How can I confirm a certain column's existence in x number of UIM database tables (origin column, for example), when troubleshooting an issue ?

Instructions:

The following SQL query can be used to find all the tables where a certain column exists:

SELECT table_name, column_name
FROM information_schema.columns
WHERE table_schema = 'nimsoftslm'
AND column_name = 'origin';

Additional Information:

As always, please contact CA Technologies support for CA UIM if you have further questions.

Environment:

Release:
Component: CAUIM