Summary
This article will demonstrate how to troubleshoot issues where the Inventoried field in Discovered Devices is potentially incorrect or not.
Question
In the All Discovered Devices node, not all devices show Inventoried = Yes despite an agent being installed. How can I check whether it should be showing as inventoried or not?
Answer
Please use the following SQL query on your FNMP database to have a look at the relevant information we have for devices:
SELECT dd.DeviceName,
dd.ComputerID,
cc.ComputerName,
cc.ComplianceComputerID,
cc.InventoryAgent,
cc.HardwareInventoryDate,
cc.InventoryDate,
CASE cc.InventoryAgent
WHEN 'ManageSoft'
THEN
CASE WHEN cc.HardwareInventoryDate IS NULL
THEN 'No'
ELSE 'Yes'
END
WHEN 'FlexNet Manager Suite'
THEN
CASE WHEN cc.HardwareInventoryDate IS NULL
THEN 'No'
ELSE 'Yes'
END
ELSE
CASE WHEN cc.InventoryDate IS NULL
THEN 'No'
ELSE 'Yes'
END
END AS Inventoried
FROM DiscoveredDevice dd
LEFT OUTER JOIN ComplianceComputer cc on cc.ComplianceComputerID = dd.ComputerID
WHERE dd.DeviceName like '%MyDeviceName%'
You'll need to change the dd.DeviceName in the WHERE clause for a known device and then the Inventoried column should say Yes or No as applicable. Or to view all devices, simply comment out (using --) or remove the WHERE clause line.
Provided that the DiscoveredDevice record (using ComputerID) is linked to the relevant ComplianceComputer record (using ComplianceComputerID) then the Inventoried column is set to Yes if there is a value in the HardwareInventoryDate field.
If ComputerName or HardwareInventoryDate is NULL then this could mean that either:
- The compliance import (update inventory on the Reconcile licenses screen) has not been completing successfully
- No inventory has been reported from that device
If the query above does show a HardwareInventoryDate and is linked to the correct computer, please contact Support and upload the query results and screenshot of All DIscovered Devices to the case via the Support portal.
Additional Information
The HardwareInventoryDate is the date that the Flexera agent last collected Hardware inventory; it is not populated / updated by Oracle inventory, VMWare inventory etc, it is only Hardware inventory that updates this.
Also see the following article which describes a known issue related to the reported"Agent installed" values: Known Issue: "Agent Installed" flag on discovered device records may appear as "No" even if the agent is installed (IOJ-1805992)
