Hi!
I'm trying to get some information from Altiris Database. I need to extract some information about software licenses recorded in the database (purchased, in use, expired etc.). But I can't identify which tables and/or views in the database give me the correct information.
For example, there is a table "LicenseInUse" and a view "vSoftwareLicenseInUse", but both don't match. There is a table "Inv_Software_Purchase_Details" that give me the quantity of purchased licenses of a given software, but I don't know where I can find the quantity of this licenses that are in use.
I find out in the database a table called "DS_Data_S5-SoftwareLicenseCompliance-SemEstoqueQuery". This table has some information that I want, but I don't know what kind of table it is. It doesn't appear to be a table with "real data".
Has anyone experienced a similar situation in the Altiris?