Tables for File Inventory
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.