cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

All Inventory info in FNMS DB

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

 

(1) 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

 

If my response answered your question satisfactorily, please click "ACCEPT AS SOLUTION" to heighten visibility for future customers!

View solution in original post

(2) Replies

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

 

If my response answered your question satisfactorily, please click "ACCEPT AS SOLUTION" to heighten visibility for future customers!