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)

[#1]

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.

SELECT TOP 1 WITH TIES ist.ComplianceComputerID, ic.AgentVersion as 'VersionName', ist.InstallDate
FROM dbo.InstalledSoftware AS ist
    INNER JOIN SoftwareTitle AS st ON st.SoftwareTitleID = ist.SoftwareTitleID
    LEFT OUTER JOIN 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
    INNER JOIN SoftwareTitle AS st ON st.SoftwareTitleID = ist.SoftwareTitleID
    LEFT OUTER JOIN dbo.ImportedComputer ic ON ist.ComplianceComputerID = ic.ComplianceComputerID
WHERE st.FullName LIKE 'FlexNet Inventory %'
    AND ic.InventoryAgent = 'FlexNet Manager Suite'
    AND ic.computername = 'agentmachine001'

For more information on the FlexNet Inventory status page, see the help article FlexNet Inventory Agent Status.

Fix status

This issue has been fixed in the following FlexNet Manager Suite releases: 2020 R1.1 / Sep 2020 (Cloud), 2020 R2 (On Premises)

Other information

Affected components: Inventory, Web UI

Master issue ID: IOJ-2125525

Also known as: FNML-71094