How can I confirm a certain column's existence in x number of UIM database tables (origin column, for example), when troubleshooting an issue ?
The following SQL query can be used to find all the tables where a certain column exists:
SELECT table_name, column_name
WHERE table_schema = 'nimsoftslm'
AND column_name = 'origin';
As always, please contact CA Technologies support for CA UIM if you have further questions.