Asset & CMDB Important Tables
Submitted by mcarrier on 31 October, 2006 - 09:08
Q:
Hi, I need to gather useful information from Altiris Asset & CMDB in order to load tables in Unicenter Service Desk 11.2. I was hoping someone could tell me which tables are relevent in SQL to help me sort it out.
I need to load info such as :
- Class, Family
- Model, Manufacturer
- Service Status
- Vendor, Vendor Type
Thanks,
max
(6 votes)
More Specific?
Do you have CMS/AMS/SMS? And you are trying to perform an extract of Computers or some other type of Asset?
Maybe this helps...
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...
_ResourceGuid,
System Manufacturer,
Computer Model,
Serial Number,
System Model Number,
Asset Tag, Source,
Agent Version,
Computer Type)
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.
Tables to look at
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.
Depends what you're looking for...
See this previous post on finding tables in the NS database:
http://juice.altiris.com/tech-tip/540/finding-tabl...
Connector Solution
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