Hi Guys, I have been asked if it would be possible to somehow get paths to where some evidences are located on devices. Basically, they want to get a list of devices that an application of certain category, let's say "Computer game", was found on. The thing is they also want to know WHERE exactly the evidence was found on each device. Is it something that can be extracted from Flexera?
There is no web browser interface for reporting on file path details from multiple computers at a time.
If you are using FlexNet Manager Suite (not Flexera One ITAM) and have access to query the compliance database then you could extract this data using a SQL query. For example:
SELECT TOP 100 ic.ComputerName, ife.FileName, iifep.ExternalFilePath, ic.InventoryDate
FROM dbo.ImportedInstalledFileEvidence iife
JOIN dbo.ImportedComputer ic
ON ic.ComplianceConnectionID = iife.ComplianceConnectionID
AND ic.ExternalID = iife.ExternalID
JOIN dbo.ImportedFileEvidence ife
ON ife.ComplianceConnectionID = iife.ComplianceConnectionID
AND ife.ExternalFileID = iife.ExternalFileID
JOIN dbo.ImportedInstalledFileEvidencePath iifep
ON iifep.ComplianceConnectionID = iife.ComplianceConnectionID
AND iifep.ExternalFilePathID = iife.ExternalFilePathID
If you have a small environment (so not too much data to be managing) then configuring custom report objects to report on evidence data like described in the solution marked on the following thread might also be an option: Unrecognized Evidence Report.
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
Flexera can import this machine with the game listed but it will see the application game and categorize it as one of the following;
Driver Game Help file Hotfix, patch, update Installer, setup Insufficient information Knowledge Base Language pack or other language-related files Miscellaneous application add-on, plugin or other negligible files Miscellaneous OS file/service Uninstaller Unreadable foreign characters
After that it will be marked as Irrelevant when Flexera tries to Normalize the data.
You can ask for a Gap Report and see the game listed and see which machine it lives on.
@RKelley3 - I suspect your comments here may be about Flexera's Data Platform product, while (based on the forum this post is in) I believe the topic of this thread is about FlexNet Manager Suite (or Flexera One ITAM).
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
Details of file path can be found under the File section of the Evidence tab when viewing an individual inventory device record:
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
Yes, I'm aware of this. And this is the reason why I think there must be a way to create a report/get a list that would contain all devices that applications of certain category were found on, along with the paths to evidences. I might be repeating myself, but I really don't know how else I can put it. 😊
There is no web browser interface for reporting on file path details from multiple computers at a time.
If you are using FlexNet Manager Suite (not Flexera One ITAM) and have access to query the compliance database then you could extract this data using a SQL query. For example:
SELECT TOP 100 ic.ComputerName, ife.FileName, iifep.ExternalFilePath, ic.InventoryDate
FROM dbo.ImportedInstalledFileEvidence iife
JOIN dbo.ImportedComputer ic
ON ic.ComplianceConnectionID = iife.ComplianceConnectionID
AND ic.ExternalID = iife.ExternalID
JOIN dbo.ImportedFileEvidence ife
ON ife.ComplianceConnectionID = iife.ComplianceConnectionID
AND ife.ExternalFileID = iife.ExternalFileID
JOIN dbo.ImportedInstalledFileEvidencePath iifep
ON iifep.ComplianceConnectionID = iife.ComplianceConnectionID
AND iifep.ExternalFilePathID = iife.ExternalFilePathID
If you have a small environment (so not too much data to be managing) then configuring custom report objects to report on evidence data like described in the solution marked on the following thread might also be an option: Unrecognized Evidence Report.
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
The following query has been extended to include details of applications files are linked to via file evidence recognition rules:
SELECT ic.ComputerName, ife.FileName, iifep.ExternalFilePath, ic.InventoryDate, er.RuleDefaultString, st.FullName
FROM dbo.ImportedInstalledFileEvidence iife
JOIN dbo.ImportedComputer ic
ON ic.ComplianceConnectionID = iife.ComplianceConnectionID
AND ic.ExternalID = iife.ExternalID
JOIN dbo.ImportedFileEvidence ife
ON ife.ComplianceConnectionID = iife.ComplianceConnectionID
AND ife.ExternalFileID = iife.ExternalFileID
JOIN dbo.ImportedInstalledFileEvidencePath iifep
ON iifep.ComplianceConnectionID = iife.ComplianceConnectionID
AND iifep.ExternalFilePathID = iife.ExternalFilePathID
LEFT OUTER JOIN (
dbo.ImportedFileEvidenceMapping ifem
JOIN dbo.SoftwareTitleFileEvidence stfe ON stfe.FileEvidenceID = ifem.FileEvidenceID
JOIN dbo.EvidenceExistenceRuleI18N er ON er.EvidenceExistenceRuleID = stfe.EvidenceExistenceRuleID AND er.RuleDefaultString IN ('Required', 'At least one')
LEFT OUTER JOIN dbo.SoftwareTitle st ON st.SoftwareTitleID = stfe.SoftwareTitleID
) ON ifem.ComplianceConnectionID = iife.ComplianceConnectionID AND ifem.ExternalFileID = iife.ExternalFileID
(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
