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

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.

Was this article helpful? Yes No
No ratings
Comments
dsalter
By
Level 6

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
Last update:
‎Dec 16, 2020 10:12 PM
Updated by: