Summary
This article covers a scenario where inventory records may periodically disappear when running ILMT as an inventory source, this provides a particular reason as to why this could occur.
Symptoms
From one day to another some servers appear or disappear from the inventory. We are using ILMT as an inventory source.
Cause
This is likely to be caused by the ILMT agent ID being duplicated for multiple inventory records.
Resolution
To resolve this please refer to your ILMT team to review the agent IDs as this may have been caused by cloning images of the devices.
To help identify the number of duplicated IDs please use the query below:
USE FNMS
SEELCT ILMTAgentID, COUNT(ILMTAgentID) AS 'Occurances'
FROM ComplianceComputer
GROUP BY ILMTAgentID HAVING COUNT(ILMTAgentID)>1