• Connection Name reflects the primary inventory source configured in Data Inputs. If FlexNet Manager Suite is set as the primary source, and the device is inventoried by a Flexera Inventory tool (Agent, Lite Agent, or Zero Touch), this column will display "FlexNet Manager Suite."
• Last Inventory Source represents the most recent inventory data received for the device, regardless of the primary source. When this column shows "SMS" and the Connection Name shows "FlexNet Manager Suite," it usually indicates that SCCM inventory has a newer date and time than the Flexera inventory.

• The SCCM agent may have inventoried the device earlier the same day, creating a fresher timestamp than the Flexera Agent or Lite Agent.
• The Flexera inventory may not be updating if there is a discrepancy in the inventory date between the two sources.

SELECT ccn.ConnectionNameDisplayName, ic.InventoryAgent, ic.InventoryDate, ic.*
FROM ImportedComputer ic
JOIN ComplianceConnection ccn ON ccn.ComplianceConnectionID = ic.ComplianceConnectionID
WHERE ic.ComputerName = 'ComputerNameGoesHere'