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 can I list the tables in the Altiris database?

book

Article ID: 240673

calendar_today

Updated On:

Products

IT Management Suite Client Management Suite

Issue/Introduction

The customer would like to list the tables in the Altiris database (Symantec_CMDB). 

What is the database Schema for the Symantec_CMDB?

Resolution

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'