Video Screencast Help

Tables for File Inventory

Created: 19 Jul 2012 • Updated: 29 Aug 2013 | 2 comments
This issue has been solved. See solution.

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.

Comments 2 CommentsJump to latest comment

JimChud's picture

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.

Regards Jim.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem and give a thumbs up to useful comments, articles and downloads.

mclemson's picture

What about RMV_Installed_File_Inventory?

SELECT * FROM RMV_Installed_File_Inventory

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

SOLUTION