All Inventory info in FNMS DB

[marcog]

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

[jjensen · Accepted solution]

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

[marcog]

Thanks a lot