marcog
Consultant

is it possible to import rvtools in FNMS

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!

0 Kudos
4 Replies
mfranz
Shining star

Re: is it possible to import rvtools in FNMS

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

Softline Group is Europe's leading independent expert in Software Asset Management.
kclausen
Flexera
Flexera

Re: is it possible to import rvtools in FNMS

@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
Consultant

Re: is it possible to import rvtools in FNMS

Thanks guys but which tables are involved in vmware inventory?
0 Kudos
mfranz
Shining star

Re: is it possible to import rvtools in FNMS

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

Softline Group is Europe's leading independent expert in Software Asset Management.