How is the Inventoried field in Discovered Device determined?

How is the Inventoried field in Discovered Device determined?

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:
  1. The compliance import (update inventory on the Reconcile licenses screen) has not been completing successfully
  2. 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.
Labels (1)
Was this article helpful? Yes No
No ratings
Version history
Revision #:
1 of 1
Last update:
‎Dec 11, 2018 10:49 PM
Updated by: