Hi all,
I'm trying to get used in navigating the FNSM Dbs.
Do you know from which table I can get the info shown in All Inventory page?
Thanks
additionally I would be happy to now if a documentation that describes db tables exists
‎Nov 15, 2020 07:03 PM
Hello @marcog,
The 'All Inventory' page is populated by a view named Grid_ComputersListModel, which resides in the Compliance database.
The schema reference guide describes all tables (not views) in the Compliance and Inventory databases: https://docs.flexera.com/fnms/EN/Schema/index.html
In this particular scenario, you are most likely interested in the ComplianceComputer table, as that is where most of the 'final' data is stored for an inventory device record.
HTH,
Joseph
‎Nov 16, 2020 12:59 AM
Hello @marcog,
The 'All Inventory' page is populated by a view named Grid_ComputersListModel, which resides in the Compliance database.
The schema reference guide describes all tables (not views) in the Compliance and Inventory databases: https://docs.flexera.com/fnms/EN/Schema/index.html
In this particular scenario, you are most likely interested in the ComplianceComputer table, as that is where most of the 'final' data is stored for an inventory device record.
HTH,
Joseph
‎Nov 16, 2020 12:59 AM
‎Nov 16, 2020 05:15 AM