ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
How to find columns on various UIM database tables ?
Article ID: 34722
Updated On:
Products
DX Unified Infrastructure Management (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
Component: CAUIM
Feedback
Yes
No
Powered by
