Inventories with NULL 'ComplianceComputerID' in "Imported Computer" table in compliace db are not present in "compliance computer" table and hence not visible in FNMS UI (All Inventory). How can we fix this issue. Let us know if there is any issue with writer/suggest any fix in DB.
PFA - log file (zip) for sample inventory with above case, .ndi file for one of the inventory with above case.
Looking forward for a solution on this import issue.
Jun 25, 2023 02:35 PM
Can you please check within the compliance database the following: dbo.ImportedMissingComputer and join it with the ImportedComputer table via external ID and see if the IsTerminated column is equal to 1 for the following devices.
Jun 29, 2023 03:12 PM
I got a result for below query -
FROM dbo.ImportedMissingComputer_MT imc
JOIN ImportedComputer_MT ic ON ic.ExternalID = imc.ExternalID
WHERE imc.IsTerminated = 1
but from this result 128 inventories are present in FNMS.
Hi @durgeshsingh , as discussed we got some azure inventories reporting in FNMS last week after cleanup, but now again they are not visible in FNMS.
Please help me if there is any other solution to fix this.
Jul 03, 2023 04:58 AM
When a Azure Virtual Machine is reported as Terminated or no longer present in the output of the Microsoft Azure connector, they'll be reported as Terminated in ImportedMissingComputer.
This would lead to the Inventory record being removed from ComplianceComputer - they are no longer an active Virtual Machine, and the Agent would not continue to report fresh Inventory.
Could you clarify whether these devices are reported as Terminated in that table?
Jul 06, 2023 09:06 AM
Hello @avi0408 ,
It should be safe to remove the devices from ImportedMissingComputer as they would be recreated in the next import. After that, you should be able to see them in the UI because they are no longer set as Terminated.
Jul 11, 2023 03:14 PM
Hello @kbryla , we got the inventories back in FNMS after removing from importedmissingcomputer table. However, we still see the same issue of some inventories getting vanished from FNMS 'All inventory' after couple of reconciliations.
Jul 26, 2023 09:07 AM