Evidence Rules

[stillgoodenuff]

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. 

[mfranz]

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

[stillgoodenuff]

Thank you for your quick reply to this query. We shall see if your suggested solution will work for us.

Best Regards,

Jeff

[ChrisG]

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:

• Evidence visibility enables resolution of application recognition issues
• Ever question why a software installation in FNMS is showing up?

If you are using FlexNet On-premises then a SQL query against the compliance database as @mfranz has described is a helpful approach.

[ChrisG]

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?