aagrawal asked a question.
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?
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?
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
@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.
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
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
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
Thank you! Already implemented and our Asset Team loves it.
Quick Question: Is there documentation to create custom reports like this someplace?
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."
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 !
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.
EvidenceReportObjects