Asset & CMDB Important Tables

Do you have CMS/AMS/SMS? And you are trying to perform an extract of Computers or some other type of Asset?

If you are using notification Server and you have the HW inventory task enabled, then you should be able to see this table in the Altiris DB - Inv_AeX_HW_Serial_Number . This table contains the following fields...

I believe if you do a distinct select on this table you should at least take care of your model/manufacturer needs....

Select distinct [System Manufacturer],
[Computer Model] from dbo.Inv_AeX_HW_Serial_Number

Not sure... maybe you could better define your other requirements.

The database has all inventory tables starting with inv_. All events start with evt_. While this comment is not as specific as Dolemite, hopefully it helps understand how named the tables.

If you need a primary key for the computers, use the 'item' table and the classguid of computer ('539626D8-A35A-47EB-8B4A-64D3DA110D01')

or vComputer is a view that has all computers.

See this previous post on finding tables in the NS database:

http://juice.altiris.com/tech-tip/540/finding-tabl...

Connector Solution makes this very easy to do by exporting Altiris CMDB info into CA.

From an SQL perspective, these are all useful replies. Additionally I would add that there is a great product called SQL Diagrams by Skilled Software that can visually show relationships. http://www.skilledsoftware.com/sqldiagrams.htm

I planned on building another Juice White Paper on the Altiris Schema using it.

Thanks,

James "Scott" Hardie
Vice President of Technology Services
shardie@xcendgroup.com
http://www.xcendgroup.com