Known Issue: FlexNet Inventory Agent Status page may show incorrect agent version when multiple imported computer records are mapped to a single inventory device (IOJ-2125525)
Known Issue: FlexNet Inventory Agent Status page may show incorrect agent version when multiple imported computer records are mapped to a single inventory device (IOJ-2125525)
Summary
An incorrect device version can appear in the Last Reported Version column of the FlexNet Inventory Agent Status page if there are multiple records for the same device. Multiple records can occur for various reasons but often originate from data inconsistencies or inaccurate data cleanup.
Troubleshooting
To investigate this issue in a FlexNet Manager Suite system, you can review details in your compliance database and remove any outdated records for a device.
Use the query below to troubleshoot the information displayed on the FlexNet Inventory Status page (Discovery & Inventory > FlexNet Inventory Agent Status). This query provides the data that generates the information you see on the status page.
SELECTTOP 1 WITHTIES ist.ComplianceComputerID, ic.AgentVersion as'VersionName', ist.InstallDate
FROM dbo.InstalledSoftware AS ist
INNERJOIN SoftwareTitle AS st ON st.SoftwareTitleID = ist.SoftwareTitleID
LEFTOUTERJOIN dbo.ImportedComputer ic ON ist.ComplianceComputerID = ic.ComplianceComputerID
WHERE st.FullName LIKE'FlexNet Inventory %'AND ic.InventoryAgent = 'FlexNet Manager Suite'
You can adjust the query to locate records for a particular device name, as shown below. In this example, the query searches for agentmachine001.
SELECT ist.ComplianceComputerID, ic.ComputerName, ic.AgentVersion as'VersionName', ist.InstallDate
FROM dbo.InstalledSoftware AS ist
INNERJOIN SoftwareTitle AS st ON st.SoftwareTitleID = ist.SoftwareTitleID
LEFTOUTERJOIN dbo.ImportedComputer ic ON ist.ComplianceComputerID = ic.ComplianceComputerID
WHERE st.FullName LIKE'FlexNet Inventory %'AND ic.InventoryAgent = 'FlexNet Manager Suite'AND ic.computername = 'agentmachine001'
Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.