cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Owner: Nicolas Rousseau
  • Solution Type: Custom SQL Reports
  • Flexera Product & Version: FNMS on Premise
  • Environment:
  • Development Effort: 2 day
  • Implementation Days: 0.1 Day
  • Pre-Requisites: DB access with read write access
  • Disclaimer: 

    SOLUTIONS ARE PROVIDED ON AN "AS IS" BASIS. NEITHER FLEXERA NOR ITS SUPPLIERS MAKE ANY WARRANTIES, EXPRESS OR IMPLIED, STATUTORY OR OTHERWISE, INCLUDING BUT NOT LIMITED TO WARRANTIES OF MERCHANTABILITY, TITLE, FITNESS FOR A PARTICULAR PURPOSE OR NONINFRINGEMENT. LICENSEE MAY HAVE OTHER STATUTORY RIGHTS. HOWEVER, TO THE FULL EXTENT PERMITTED BY LAW, THE DURATION OF STATUTORILY REQUIRED WARRANTIES, IF ANY, WILL BE LIMITED TO THE SHORTER OF (I) THE STATUTORILY REQUIRED PERIOD OR (II) THIRTY (30) DAYS FROM LICENSEE’S ACCEPTANCE OF THE AGREEMENT.

    Set of reports that provide relevant information to address the following inventory gaps analysis:

    Virtual Machines collected from vCenter but not inventoried

    The report catches inventoried and not inventoried VMs (reported by vCenter import) with information that will help closing the gaps (host entity etc.).

 

VM Gaps.pngMerged Computers (leading to license consumption false positives)

 

The document gives more details, but it can happen the multiple "imported computers" coming from multiple sources or even from the same are merged by the import. If the computers inventory dates are the same (two different sources (SCCM and FNMS agent) for the same computer), there is no issue. If one of the merged records is aging, this can lead to false positives. It is always good to delete old records that are merged from the source database.

Merged Computers Report.png

Note that a menu introduced with FNMS 2020R2 shows the matching criteria. The report focuses on the merged computers

 Device Matching.png

 

Oracle Inventory Collection issues

Understanding when an Oracle inventory fails can be extremely time consuming (need to check the logs on discovered device.

The report will catch all issues and show the last error logs. It will prioritize the issues based on issue type of logs information.

Oracle Inventory Quality Troubleshooting.png

vCenter Inventory Issues

Collecting correctly vCenter inventory is critical as the most expensive server licenses require the knowledge of the host / VMs links.

The “All Discovered Devices” screen contains valuable information (VMWare inventory date, VMWare discovery date etc.), but analyzing the data may be complex because the logs must be accessed one by one on the “status” tab of the discovered devices, and data such as virtualization product and versions are not available a screen column.

It collects the following information

vCenter data collected.png

 Preview:

PreviewvCenter.png

 

 

 

Duplicate Computers (leading to orphan VMs (Ghost ESX))

Please refer to the Word document for detais... two ESX server with the same UUID will trigger an "isDuplicate" flag that will cause the deletion of the duplicate record and will make related VMs orphan. The reports shows such duplicate ESX servers.

ESX Ghosts Troubeshooting.png

 

 

Was this article helpful? Yes No
0% helpful (0/1)
Comments
durgeshsingh
By
Level 10

Team,

 

These code need to run against FNMS compliance Or IM DB.

nrousseau1
By Level 10 Champion
Level 10 Champion

Hello,

FNMS is the database to run the code to get the reports.

Best regards,

Nicolas

Version history
Last update:
‎Apr 12, 2022 04:24 AM
Updated by: