- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- Re: All Inventory info in FNMS DB
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
