Is there a way to run a report on Unrecognized Evidence?
I'm currently running a report on Installed Devices (Using the Installations metric), which gives me a device name for all computers running a software title by version. Is this possible using Unrecognized Evidence as well?
Apr 17, 2019 05:45 PM
Hi,
Installer or file evidences are not in the data model of FNMS reports builder, so you can't build reports with report builder that include evidences. It would be beneficial to have evidences added to the data model, however at the moment you can only rely on workarounds.
Currently it is possible to fetch list of Inventory devices having one or another evidence directly from FNMS Database. It is also possible to map such custom SQL query on reports builder and show results in WebUI. Attaching example SQL code for the report I am currently building in our environment, it allows to create report returning the list of devices having installer evidence.
Marius
Apr 18, 2019 02:43 AM
Hello Akshay,
I have two reports I would like to share on evidences.
Apr 19, 2019 02:11 AM - last edited on Aug 28, 2022 08:01 PM by ChrisG
The attached script can be run against the FlexNet compliance database for an on-premises installation to configure a range of custom report objects that may be helpful for troubleshooting and digging in to raw evidence details and application recognition results. These report objects will expose details of evidence that has been imported, and how that evidence maps to inventory devices, recognition rules and applications.
The following objects (and associated relationships) are defined:
It is easy to generate reports containing massive amounts of data with these objects. For example, you could easily build a report listing all raw file evidence found on all computers (ouch!). Use prudent filtering to avoid generating too much data!
Some example screenshots of reports that can be configured using these objects follow.
A consideration to be aware of with these custom report objects is that they rely on data that is directly written into the compliance database by inventory "reading" processes that extract data from inventory sources (such as SCCM, the FlexNet inventory database, etc). As such, it may take a long time to run reports using these objects while inventory "reading" processes are running. I can also imagine some possible situations where the data shown in the reports may be unreliable if reports are run between when inventory "reading" and "writing" processes are run.
Apr 22, 2019 07:19 AM - edited Jun 03, 2020 05:05 AM
Good Afternoon,
You can view unrecognized Evidence in the webui and export to excel by going to ‘License compliance\ unrecognized Evidence’. Unfortunately, that will not tie to a device.
I have never seen an option to build a report in the ‘Report Builder’ that includes evidence.
I certain there is not currently an option for that type of report in the UI.
Are you using cloud of on prem?
Apr 17, 2019 06:03 PM
Hi,
Installer or file evidences are not in the data model of FNMS reports builder, so you can't build reports with report builder that include evidences. It would be beneficial to have evidences added to the data model, however at the moment you can only rely on workarounds.
Currently it is possible to fetch list of Inventory devices having one or another evidence directly from FNMS Database. It is also possible to map such custom SQL query on reports builder and show results in WebUI. Attaching example SQL code for the report I am currently building in our environment, it allows to create report returning the list of devices having installer evidence.
Marius
Apr 18, 2019 02:43 AM
@marius that is a good looking report. @agrawalakshay1 to get only unassigned evidences add this to the WHERE clause:
IEI.IsAssigned = 0
Also IEI.OperatorManagedState and IEI.Ignored might be interesting, to see if the evidence is ARL based or local and maybe ignored on purpose.
Apr 18, 2019 09:12 AM
Marius,
I just put this into our DEV environment and my Asset Management Team LOVES it. In fact, they love it so much they want to PROD ASAP. In addition, they were wondering if you had something similar for FILE evidence?
Thanks!
Jason
Apr 18, 2019 03:24 PM
Apr 18, 2019 11:42 PM
Marius,
Thanks for the hint, but with a busy as we are I likely wouldn't get to it before you! If you could send me an update when the File evidence is complete that would be fantastic!
Jason
Apr 19, 2019 06:17 AM
Hi, @jaalstead ,
finally got some time to finalize reports. Attaching scripts that we are going to deploy into production.
In zip file you will find two reports one for Installer evidences, another for File evidences.
Marius
Apr 29, 2019 02:31 AM
Thank you! Already implemented and our Asset Team loves it.
Quick Question: Is there documentation to create custom reports like this someplace?
May 01, 2019 07:05 AM
Hi, I was not able to get documentation. So it took some time to analyse existing default reports and build own. Used Nicolas Rousseau's reports to find existing tables, and then used trial and error approach.
On documentation request I got this response from @ChrisG :
"Frankly, when getting to this level of tweaking you are starting to work with internal system details that are not intended to be directly accessed or used - hence you won't find any documentation for this. I'm not wanting to discourage you from being adventurous and enjoying the power of working directly at this level, but please understand that it is an approach that you won't find any formal support for."
May 03, 2019 01:31 AM
Nicolas Rousseau's "evidences on computer (NR)"report may help on that .
It is very useful in a lot of my investigations... You can either :
You'll find the SQL script for the view enclosed, but you may check with him if he doesn't have a more recent version of it !
Apr 18, 2019 10:16 AM
Hello Akshay,
I have two reports I would like to share on evidences.
Apr 19, 2019 02:11 AM - last edited on Aug 28, 2022 08:01 PM by ChrisG
Oct 03, 2019 02:39 PM
Hi @kathy_allen ,
While I can't comment on the custom report, have you seen this thread as it relates to a feature we added to help with evidence / application recognition?
That feature is something that will be kept current with releases.
Hope this helps,
Matt
Oct 04, 2019 11:24 AM
The attached script can be run against the FlexNet compliance database for an on-premises installation to configure a range of custom report objects that may be helpful for troubleshooting and digging in to raw evidence details and application recognition results. These report objects will expose details of evidence that has been imported, and how that evidence maps to inventory devices, recognition rules and applications.
The following objects (and associated relationships) are defined:
It is easy to generate reports containing massive amounts of data with these objects. For example, you could easily build a report listing all raw file evidence found on all computers (ouch!). Use prudent filtering to avoid generating too much data!
Some example screenshots of reports that can be configured using these objects follow.
A consideration to be aware of with these custom report objects is that they rely on data that is directly written into the compliance database by inventory "reading" processes that extract data from inventory sources (such as SCCM, the FlexNet inventory database, etc). As such, it may take a long time to run reports using these objects while inventory "reading" processes are running. I can also imagine some possible situations where the data shown in the reports may be unreliable if reports are run between when inventory "reading" and "writing" processes are run.
Apr 22, 2019 07:19 AM - edited Jun 03, 2020 05:05 AM
Hi, @ChrisG ,
your provided script to extend data model looks very promising, as it should enable number of evidence related elements in the FNMS reports.
Data model extension is developed, any thoughts why it is not added to build-in data model. Do you see any risks on future upgrades if this data model extension will be deployed on on-premise setup?
Marius
Apr 29, 2019 02:48 AM
@marius - as a customization, it is certainly possible that a change may be made in a future FlexNet release which results in the data model extension no longer working. However I expect (without testing) that the extensions will work with all current FlexNet releases, as the database schema involved is not something that has changed for many years.
Apr 29, 2019 02:54 AM
Is still working this in 2019 R2? or 2020 R2?.
Thanks.
Jan 26, 2021 05:18 AM
@lcfernandez - The "Evidence" tab on an inventory device was added as a standard feature in FNMS 2019 R2.
Jan 26, 2021 06:22 AM
@kclausen , i know, but what we wanted is export for all devices who have evidences for a specified vendor.
Regards.
Jan 26, 2021 07:45 AM