Where are example SQL Queries for Associations?
Submitted by Juicemaster on 11 July, 2006 - 13:03.
Q:
Luis wrote, "How do I get example SQL Queries for Associations and other data?"
A:
Luis, in the Reports tab in the Altiris Console there is a Report called Resource Management Metadata. The report location is:
Reports -> Assets and Inventory -< Inventory -> Win32 -> Inventory Agent -> Resource Management Metadata
This report allows you to select the data you want to return, Associations or data classes, and it will give you an example SQL query that returns that data.
(3 votes)
- Login or register to post comments
- 2992 reads
- Printer-friendly version
Get to Know the ResourceAssociation Table
That's your ticket, Luis.
I tend to figure this stuff out by poking around the database. The RA table is pretty simple, acutally. It has 4 columns:
ParentResourceGuid
ChildResourceGuid
ResourceAssociationTypeGuid
&
CreatedDate
The createddate is fairly self-explanatory. The other three indecipherable, until you join them to the item table using the item.guid column as the link...then you get the item.name as a plain-english translation of what the GUID means.
SQL Queries For Associations
As someone who is new to writing reports for Altiris, I found the views that are built in SQL enterprise manager the most helpful.
That helps to visually see the connections between resource association tables etc!
Have Fun!