Evidence reporting isn't available in standard FNMS reporting. Reasons understood.
Playing through My Analytics/Cognos reporting, however, makes me wonder if I'm close.
You might expect that the output of this report might show you a list of individual bits of evidence found on each machine, within the context of how you set any filters.
Ex. show me all computer names with file evidence Java.exe 8% AND 9%
The output of this, however, doesn't logically join the computer and evidence. It just gives a side-by-side list of the top level tables themselves. Is this a dead end or am I on to something?
Jun 24, 2021 01:46 PM
AFAIK the Flexera's Analytics data models don't include the required details to be able to match file evidence with the compliance computers on which it was discovered. FYR, the link is in InstalledFileEvidence Table and you would as such have to work with the compliance database schema directly from Analytics to get started.
Jun 28, 2021 06:11 AM
As stated by @JohnSorensenDK , yes you can connect to the compliance data schema using cognos - so you could show any data from the compliance db.
So your actual challenge is to get the query right - and you can do that straight in SQL.
Here is an example of evidence reporting that you can adapt. Do be careful to mange the volume of results which could be problematic.
Jun 29, 2021 01:40 AM
Jun 29, 2021 06:44 AM
That's correct, and you're also limited to the Flexera Analytics data models then...
I would recommend that you raise your needs through the ideas portal, e.g. that Flexera extends its API's to facilitate the data extraction required for your use cases (and please make sure to include the business value of it to your organization) or add your vote and your comments to Getting Custom reports Using API .
Jun 29, 2021 10:09 AM
Based on the user session, a test report was created to view the data elements.
Objective was to use the file name provided by file evidence and identify computers associated with that file name.
First query was built from: FNMP>Operational Objects>Software Title (Application)> Software Title File Evidence Link and File Evidence.
Data Items in the query: File Evidence. FileEvidenceID, File Evidence.File Name, Software Title File Evidence Link.FileEvidenceID, Software Title File Evidence Link.SoftwareTitleID, Software Title File Evidence Link.Version
Second query was built from: FNMP>Operational Objects>Computer> VM Host Installation Link
Data Items in the query: VM Host Installation Link.SoftwareTitleID, VM Host Installation Link.InstalledSoftwareID, VM Host Installation Link.Computer Name, VM Host Installation Link.Last Used Date
A final query was created by joining these two above queries using an inner join on SoftwareTitleID. This final query contained data items from the above queries.
On a side note: To test if the queries are bringing the correct results, always use filtered data set so that it is easier to test the intial query set-up with the filtered data set.
Jun 30, 2021 03:42 PM