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.
The code is in attached Word document
This document gives the details for collecting data from Nutanix or Red Hat RHEV cluster and integrating the data into FNMS / Flexera One ITAM
The integration also creates Virtual Machines that would not be inventoried but assumes the full inventory is coming from an inventory tool (FNMS agent, SCCM) that include applications inventory. This creation is native in the Spreadsheet adapter design, you can choose to ignore the VMs that have no detailed inventory…
The approach is to read the data in the Cluster Management source (Nutanix Prims / Cluster REST APIs or RHEV mySQL database) and generate the files (Cluster.csv, Compuiter.csv, used as a pivot format) that will be located in the folder that a specific Inventory Spreadsheet Adapter, created from the Beacon UI will read.
The solution works for both on premise and cloud instances.
The spreadsheet adapter expects each column of the templates to exist in the file that will be consumed, but does not require all files of the templates (file evidence, installer evidences etc.) to be present. This, the two integrations below provide the minimum number of files (computers and clusters) but all the columns (very often empty) in the spreadsheet. Note that these are the 2021R1 templates and that an implementation in a future version of FNMS may require to re-align the queries selections with the current template.
To be noted the ComputerID or HostComputerID can be stings in ImportedComputer. The UUID for the sources have been used in these two integrations, in the absence on database ID (integer or bingint).
The read operation will be typically scheduled (from the Windows Scheduler) once a day at 3:00 PM, the Beacon Spreadsheet adapter will be scheduled at 5:00 PM (before the Inventory import and reconcile task that runs once a day typically at 10:00 PM or 00:00.
There are prerequisites that need to be applied in the two integrations
There are ways to encrypt password in PowerShell, please refer to a PowerShell expert to do this.
Feb 16, 2023 03:37 PM