Import IPs from VMware vCenter Hosts

[weidi]

Was trying to import IPs from Hosts in vCenter to Netbox, this is what i endet up with

Connect-VIserver vcenter.fqdn
Connect-NetboxAPI -Hostname netbox.fqdn

function Import-vCenterIPs
{
    foreach($interface in get-vmhost | Get-VMHostNetworkAdapter -VMKernel)
    {   
        $description = "MGMT: $($interface.ManagementTrafficEnabled), vMotion: $($interface.vmotionenabled), FT: $($interface.FaultToleranceLoggingEnabled), vSAN: $($interface.VsanTrafficEnabled)"
        New-NBIP -IP $interface.IP -SubnetMask $interface.SubnetMask -DNSName $interface.VMHost -description $description 
    }    
}

function Convert-IpAddressToMaskLength([string] $NetMask)
{
  $result = 0; 
  # ensure we have a valid IP address
  [IPAddress] $ip = $NetMask;
  $octets = $ip.IPAddressToString.Split('.');
  foreach($octet in $octets)
  {
    while(0 -ne $octet) 
    {
      $octet = ($octet -shl 1) -band [byte]::MaxValue
      $result++; 
    }
  }
  return $result;
}


function New-NBIP 
{
    [CmdletBinding()]
    param (
        [IPAddress] $IP,
        [IPAddress] $SubnetMask, 
        [string] $DNSName,
        [string] $description, 
        [string] $ItsmID = "ITSMID1234"
    )

    #Get Tenant / VRF Info
    $PrefixInfo = $(Get-NetboxIPAMPrefix -Query $IP)[-1]
    #Building CIDR IP 
    $IPCidr = [string]$IP+"/"+$(Convert-IpAddressToMaskLength $SubnetMask)
    If($PrefixInfo.VRF)
    {
      New-NetboxIPAMAddress -Address $IPCidr -Dns_name $DNSName -Custom_Fields @{sm=$ItsmID} -Tenant $PrefixInfo.Tenant.id -Description $description -VRF $PrefixInfo.Tenant.VRF
    }
    else 
    {
      New-NetboxIPAMAddress -Address $IPCidr -Dns_name $DNSName -Custom_Fields @{sm=$ItsmID} -Tenant $PrefixInfo.Tenant.id -Description $description
    }
}

Hope this is helpful to some of you.