is it possible to import rvtools in FNMS

[marcog]

Hi community,

for some reason really long to explain, we are not able to reach some vmware vcenters with FNMS to complete the inventory. The customer was anyway able to run RVTOOLS on the same vcenter server and get the information he needs.

We were wondering if there is any way or any direction to import the rvtools output in FNMS, avoiding to waste other time trying to reach the vcenter server.

Thanks!

[mfranz]

Hi,

According to the RVTools website, the output would XLSX files. I guess you could use a Business Import to stage the data and do some fancy SQL to import:

• Clusters,
• Hosts,
• Cluster-Host-relationships,
• possibly VMs
• and Host-VM-relationships.

Best regards,

Markward

[kclausen]

@marcog - Unfortunately, there is not a built-in method to import the output from RVTOOLS into FNMS to replace the vCenter connection.

If you have FNMS On-Premises, then as @mfranz suggests, you can take in the data and update FNMS using raw SQL, but this would require a very high level of expertise for the Compliance Database Schema.

[marcog]

Thanks guys but which tables are involved in vmware inventory?

[mfranz]

Hi,

Those are the tables:

SELECT * FROM Cluster_MT
SELECT * FROM ComplianceComputer_MT
SELECT * FROM ClusterComputer_MT
SELECT * FROM VirtualMachine_MT

But there's some complexity behind this, for example a VM has an entry in ComplianceComputer_MT and VirtualMachine_MT. Also, duplicate entries in ClusterComputer_MT will mess with some views in the WebUI, you'll need to make sure to update existing entries, instead of adding new stuff.

I am not sure about your experience with the FNMS databases, but you might want to consider professional services for this one.

Best regards,

Markward