@shill2 - Regarding the email that you shared from wdarrough, I would like to clarify one statement.
The upcoming change in FNMS Cloud is against the raw evidence. You will be able to search for a specific piece of raw evidence in the Unrecognized Evidence view and the Discovered Evidence view. Within the properties of the evidence, the new Devices tab will list which computers this piece of raw evidence is installed on.
We have FNMS 2019R1 (on prem). I have tried using the sql file that you shared here. But it did not work for me. The query ran successfully with a message - 1 row affected.
However, it did not create any custom report in FNMS Reports>GUI.
Can you please help how to execute it correctly. Also can you please share similar sql file to extract machine wise file evidence report
@mfranz - I have also tried to create a custom report, but could not find any columns related to evidence. Can you please guide
@rajeshponnala - For future consideration, FNMS 2020 R1 has this capability built in.
When you go into the Properties of a piece of Evidence (Installer or File), there is a Devices tab that shows which devices this piece of Evidence is installed on.
Yes, I just saw that in our dev environment, thanks for that. Is there a way to create a full report for all such evidences and hostnames in 2020 ?
Also, how do we achieve the same in 2019 R1 as well ?
Here our problem is the customer has lots of uncrecognised/repackaged jboss evidences, so decided to pull a report of all evidences with hostnames, then can internally enquire what are the applications installed on those computers. This would help to manage 34000 unrecognized evidences.
The ability to get the "Device" tab on the properties of Evidence is a new feature and can only be obtained by upgrading to FNMS 2020 R1.
For 2019 R1, your only option is to create a SQL query. Earlier in this thread, a user has provided a SQL Query that you can use to look for certain raw evidence values, and get the list of devices that each piece of evidence is installed on.