How can we correlate Installer Evidence (of various Types) into specific evidence found on the Inventory device? File evidence shows specific filenames but Installer evidence is unspecific.
‎Jul 30, 2019 09:37 AM
Hi,
I guess you'll have to do some SQL magic. Here is an example:
SELECT DISTINCT TOP 1000 cc.ComputerName ,imie.* FROM ComplianceComputer cc JOIN InstalledInstallerEvidence inie ON cc.ComplianceComputerID = inie.ComplianceComputerID JOIN ImportedInstallerEvidenceMapping iiem ON inie.InstallerEvidenceID = iiem.InstallerEvidenceID JOIN ImportedInstallerEvidence imie ON iiem.ExternalInstallerID = imie.ExternalInstallerID AND iiem.ComplianceConnectionID = imie.ComplianceConnectionID JOIN ImportedInstalledInstallerEvidence iiie ON imie.ExternalInstallerID = iiie.ExternalInstallerEvidenceID AND imie.ComplianceConnectionID = iiie.ComplianceConnectionID JOIN ComplianceComputerConnection ccc ON iiie.ExternalComputerID = ccc.ExternalID AND iiie.ComplianceConnectionID = ccc.ComplianceConnectionID AND cc.ComplianceComputerID = ccc.ComplianceComputerID
Depending on what you want to see, you'll want to report on the InstallerEvidence as well or maybe add the SoftwareTitle to see the application.
Best regards,
Markward
‎Jul 30, 2019 10:11 AM
Thank you for your quick reply to this query. We shall see if your suggested solution will work for us.
Best Regards,
Jeff
‎Jul 30, 2019 04:46 PM
If you are using FlexNet Cloud then there is a recently released feature to view raw evidence details on inventory device records which may help to give insight here. See:
If you are using FlexNet On-premises then a SQL query against the compliance database as @mfranz has described is a helpful approach.
‎Jul 30, 2019 04:50 PM - edited ‎Aug 28, 2022 07:50 PM
Updates that can be applied to FlexNet On-premises 2018 R1 to 2019 R1 systems to show additional evidence information have now been published by Flexera. See Ever question why a software installation in FNMS is showing up?
‎Sep 12, 2019 11:21 PM