Altiris NS Collections and Tables for filtering

There are schema articles available for v6, but not v7.

Hi there,

You can get a list of the tables containing data (inventory or event types) from the NS database (6.x or 7.x) using the following query:

select t2.name as 'Solution', dc.name as 'Dataclass name', dc.datatablename as 'Data table name'
  from dataclass dc
  join item t1
    on dc.guid = t1.guid
  join item t2
    on t1.productguid = t2.guid
 order by solution, [dataclass name]

This query returns 3 colums:

1. [Solution] is the name of the solution that owns the dataclass.
2. [Dataclass name] is the name of the data class
3. [Data table name] is the name of the table where the data is stored on the database

Note that the query is sorted by solution and dataclass name, but you could add any filter to target specific solution or data type (if you are looking for event tables the datatablename will start with Evt_ whilst inventory tables start with Inv_).

I'm looking for v6, where can I download the schema or what's the link of the articule?

Thanks!

Thanks! That's what I was looking for!!! :D