Inventory devices inventoried from ADDM don't show up in FNMS UI

Inventory devices inventoried from ADDM don't show up in FNMS UI

The inventories gathered from ADDM inventory source are imported into FNMS In the following order:
ADDM staging DB (the Host_CI table) -> FNMS Compliance DB (the ImportedComputer table -> the ComplianceComputer table)

If some inventories gathered from ADDM inventory source are missing from FNMS UI, you can check the inventories with the below steps:

1. Check if the inventory record exists in the Host_CI table: If it doesn't exist, then check the ADDM inventory source as it's not imported into FNMS.

2. Check if the inventory record in the ImportedComputer table and the ComplianceComputer table
- If the IgnoredDueToLicense column in the ImportedComputer table is 1, then it will not import into the ComplianceComputer table.
- If the inventory record exists in the ComplianceComputer table but it's not reflecting in the FNMS Web UI, then check its status. Only inventory devices with a status of either Active or Ignored are displayed.

In addition, for virtual machines, if the IgnoredDueToLicense column in the ImportedComputer table is 0 but it doesn't exist in the ComplianceComputer table, then also check if the VM host info is available in the Host_CI table. This is a required column for virtual machines.

Labels (2)
Was this article helpful? Yes No
No ratings
Comments

I am using the following database query as part of a compliance process to prove ADDM computers are in FNMS

--Verify ADDM Computers are in FNMS inventory, expect results for AIX LPARs and VIO(AIX) machines as these are assigned a 
--different Serial number in FNMS than is discovered by ADDM to avoid duplication of serial numbers
SELECT *  FROM [AddmStaging].[dbo].[Host_ci]
LEFT JOIN [FNMS].[dbo].[ComplianceComputer_MT] as Comp ON [AddmStaging].[dbo].[Host_ci].Serial = Comp.SerialNo
WHERE [AddmStaging].[dbo].[Host_ci].Serial IS NOT NULL
AND Comp.SerialNo is NULL
Version history
Revision #:
2 of 2
Last update:
‎Dec 16, 2020 10:12 PM
Updated by:
 
Contributors