Hi,
Just want to ask if it is possible to link Virtual Machine to a VM Host using the Business Adapter Studio? I can't seem to find any Virtual machine or VM Host field in the Business Adapter.
Appreciate any feedback that would be provided.
Many thanks.
āJul 25, 2019 12:25 AM
Good Afternoon,
Unfortunately you can not Link a virtual machine to a host via a business adapter. However, check under 'Data Inputs'. Select the 'Inventory tab' click the 'On-off-upload' button. In this section you have templates that can be used to import inventory manually. (Including guest and host relationships.)
āJul 25, 2019 03:41 PM
Good Afternoon,
Unfortunately you can not Link a virtual machine to a host via a business adapter. However, check under 'Data Inputs'. Select the 'Inventory tab' click the 'On-off-upload' button. In this section you have templates that can be used to import inventory manually. (Including guest and host relationships.)
āJul 25, 2019 03:41 PM
Thanks you so much. Will do try to explore the One-off upload option. Cheers!
āJul 25, 2019 08:25 PM
If your FNMS is on prem, you can use a Business Import to link VMs to Hosts using SQL (custom query). No option for the cloud though.
āJul 26, 2019 08:53 AM
Hello,
I was wondering if you were able to successfully match VMs and Hosts using one-off upload.
I am not sure which templates/columns I should actually use to link VM to a host.
I have list of hosts with serial numbers already in fnms. same for VMs.
@mfranz, since we are on prem, can you also advise what tables/columns should be updated. Perhaps it would be easier to configure.
āJun 19, 2020 03:24 AM - edited āJun 19, 2020 03:31 AM
Hi,
I have used the Cluster and Computer templates.
Regarding the columns to be filled for the Computer template.
Here are just some of the columns that I think are important to be included:
ComputerID, ComputerName, SerialNo, HostID, HostComputerID, ClusterID, VirtualMachineType
Hope this helps.
NOTE: I would recommend for you to check out the demo video on Spreadsheet Imports with FNMS.
āJun 21, 2020 06:06 PM
Hi @JanPie,
This depends on what data you already have in your system. Here is an example:
If your source is just a list of VM names and host names, you'll join the data with ComplianceComputer twice, once for VMs, once for hosts and take the ComplianceComputerIDs form there.
Some additional fields might be mandatory, please check the Schema Reference for needed fields. You can try updating the tables directly, but using existing stored procedures might be smarter. Check out VirtualMachinePutBatchByComplianceComputerID, it creates and updates VM data.
Best regards,
Markward
āJun 24, 2020 07:42 AM