Client Management Suite

We run both delta and full agent based inventory for 'File Properties - manufacturer, version, size, internal name, etc.'. Does anyone know which tables are used to hold the data collected for this type of inventory? I am not sure if you have a query which you run to collect from all the different tables (I am assuming it is pretty well split up).

I looked through the tables and Inv_Installed_Files_Details / Inv_File_Details appear to be the most related, but there is a lot of data missing from these tables. I also dont see any reports that are useful on the NS server.

Any help would be appreciated. Thanks.

Hi,

The other data is more held in grouped data Inv_SW_Disk_Usage_By_File_Type something like that for example.

I haven't found other places with full data and was advised that it doesn't keep all data of everything.

Heres an example report on that uses the counts by specific file types.

https://www-secure.symantec.com/connect/forums/report-business-and-media-files-counts-and-sizes

If you're looking for details on a specific set of files custom inventory seems to be the only easy way to get that, other that using software resource reports.

What about RMV_Installed_File_Inventory?

SELECT * FROM RMV_Installed_File_Inventory