marcog
Level 8

All Inventory info in FNMS DB

Jump to solution

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
jjensen
Flexera Alumni

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
jjensen
Flexera Alumni

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

Thanks a lot
0 Kudos