The customer would like to list the tables in the Altiris database (Symantec_CMDB).
What is the database Schema for the Symantec_CMDB?
ITMS 8.x
When you run the following query on the Symantec_CMDB, it will list the tables that are in the database:
SELECT * FROM
information_schema.tables
When you run the following query on the Symantec_CMDB, it will list information about the columns in the table:
SELECT * FROM INFORMATION_SCHEMA.columns c WHERE c.table_name =
'DBSchema'