Listing the tables in the Altiris database
search cancel

Listing the tables in the Altiris database

book

Article ID: 240673

calendar_today

Updated On: 11-08-2024

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?

Environment

ITMS 8.x

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'