Hello, I noticed that there are rows in the database table ComplianceComputer_MT with ComputerNames that I cannot find back in the "All Inventory" view in FNMS. I am wondering why that is. Is there some kind of criterion that keeps some records out of the view?
‎Apr 25, 2024 02:38 AM
Hi Bleepie,
In FNMS, the information displayed in the user interface (UI) in the "All Inventories" view is retrieved from an internal staging table named [Grid_ComputersListModel_PC_MT].
Data in this staging table has a low level of normalization. The purpose of the staging table is achieving a good performance, even if with high volumes of inventories.
Data from the [ComplianceComputer_MT] table are syncronized with the [Grid_ComputersListModel_PC_MT] staging table on a regular basis. However, there is no easy way to see how this syncronization is triggered.
If you want to enforce these two tables to be syncronized immediately, you can execute the following stored procedure:
exec [dbo].[SyncTable_Grid_ComputersListModel_PC]
‎Apr 25, 2024 09:25 AM
The ComplianceComputer_MT table indeed does contain more records than are shown in the "All Inventory" grid. Some examples of the types of records you would find in the table in the database that are not visible on the "All Inventory" grid are:
‎Apr 30, 2024 06:01 AM