This topic has 7 replies, 1 voice, and was last updated August 30, 2021 by Julian M.

Export of VM/VPG data?

Ron F
November 28, 2017 11:20:50 PM

Hi,

We’re embarking on an effort to point most of our VPG’s to a different vcenter/cluster/storage/network. With our Standard licensing it appears we have to rebuild all the VPG’s (close to 200 VPG’s). I’d like to get a clean export of VM to VPG data along with configuration info such as failover network. Worst case an export that looks like the VM’s tab in the UI.

When I do an export from the VPG tab in the UI I get a really ugly spreadsheet that is useless for sorting. I’ve attempted running Get-protectiongroups from powershell and it times out (we have 5 sites).

Thanks for any insight. I’m assuming there are tables in the SQL DB that could be use but we have no direct access at least using the embedded SQL engine.

Ron F
November 29, 2017 12:07:24 AM

I was able to cobble together a script from http://s3.amazonaws.com/zertodownload_docs/5.0U4/White%20Paper%20-%20Automating%20Zerto%20Virtual%20Replication%20with%20PowerShell%20and%20REST%20APIs.pdf

This output CSV’s with much better sortable data.

Ryan S
November 29, 2017 02:22:18 PM

Thanks for the info, Ron.

I can see about updating our documentation to include this script.

Sean B
February 14, 2018 03:58:18 PM

Ron F,

Can you please post the script you used to gather the data? I’m working on a similar project and would rather not “re-invent the wheel”. 🙂

Thanks!

Ron F
February 14, 2018 04:35:01 PM

Here ya go

################################################
################################################
# Configure the variables below
################################################
$ExportDataDir = “C:\admin\”
$ZertoServer = “zvm”
$ZertoPort = “9669”
$ZertoUser = “user”
$ZertoPassword = “password”
########################################################################################################################
# Nothing to configure below this line – Starting the main function of the script
########################################################################################################################
################################################
# Setting certificate exception to prevent authentication issues to the ZVM
################################################
add-type @”
using System.Net;
using System.Security.Cryptography.X509Certificates;
public class TrustAllCertsPolicy : ICertificatePolicy {
public bool CheckValidationResult(
ServicePoint srvPoint, X509Certificate certificate,
WebRequest request, int certificateProblem) {
return true;
}
}
“@
[System.Net.ServicePointManager]::CertificatePolicy = New-Object TrustAllCertsPolicy
################################################
# Building Zerto API string and invoking API
################################################
$baseURL = “https://” + $ZertoServer + “:”+$ZertoPort+”/v1/”
# Authenticating with Zerto APIs
$xZertoSessionURL = $baseURL + “session/add”
$authInfo = (“{0}:{1}” -f $ZertoUser,$ZertoPassword)
$authInfo = [System.Text.Encoding]::UTF8.GetBytes($authInfo)
$authInfo = [System.Convert]::ToBase64String($authInfo)
$headers = @{Authorization=(“Basic {0}” -f $authInfo)}
$sessionBody = ‘{“AuthenticationMethod”: “1”}’
$TypeJSON = “application/json”
$TypeXML = “application/xml”
Try
{
$xZertoSessionResponse = Invoke-WebRequest -Uri $xZertoSessionURL -Headers $headers -Method POST -Body $sessionBody -ContentType $TypeJSON
}
Catch {
Write-Host $_.Exception.ToString()
$error[0] | Format-List -Force
}
# Extracting x-zerto-session from the response, and adding it to the actual API
$xZertoSession = $xZertoSessionResponse.headers.get_item(“x-zerto-session”)
$zertoSessionHeader_JSON = @{“x-zerto-session”=$xZertoSession; “Accept”=$TypeJSON }
$zertoSessionHeader_XML = @{“x-zerto-session”=$xZertoSession; “Accept”=$TypeXML }
################################################
# Creating Arrays for populating ZVM info from the API
################################################
$VPGArray = @()
$VMArray = @()
$VMVolumeArray = @()
$VMNICArray = @()
################################################
# Creating VPGArray, VMArray, VMVolumeArray, VMNICArray
################################################
# URL to create VPG settings
$CreateVPGURL = $baseURL+”vpgSettings”
# Build List of VPGs
$vpgListApiUrl = $baseURL+”vpgs”
$vpgList = Invoke-RestMethod -Uri $vpgListApiUrl -TimeoutSec 100 -Headers $zertoSessionHeader_XML -ContentType $TypeXML
# Build List of VMs
$vmListApiUrl = $baseURL+”vms”
$vmList = Invoke-RestMethod -Uri $vmListApiUrl -TimeoutSec 100 -Headers $zertoSessionHeader_XML -ContentType $TypeXML
# Select IDs from the API array
$zertoprotectiongrouparray = $vpgList.ArrayOfVpgApi.VpgApi | Select-Object OrganizationName,vpgname,vmscount,vpgidentifier
$vmListarray = $vmList.ArrayOfVmApi.VmApi | select-object *
################################################
# Starting for each VPG action of collecting ZVM VPG data
################################################
foreach ($VPGLine in $zertoprotectiongrouparray)
{
$VPGidentifier = $VPGLine.vpgidentifier
$VPGOrganization = $VPGLine.OrganizationName
$VPGVMCount = $VPGLine.VmsCount
$JSON =
“{
“”VpgIdentifier””:””$VPGidentifier””
}”
################################################
# Posting the VPG JSON Request to the API
################################################
Try
{
$VPGSettingsIdentifier = Invoke-RestMethod -Method Post -Uri $CreateVPGURL -Body $JSON -ContentType $TypeJSON -Headers $zertoSessionHeader_JSON
$ValidVPGSettingsIdentifier = $true
}
Catch {
$ValidVPGSettingsIdentifier = $false
}
################################################
# Getting VPG settings from API
################################################
# Skipping if unable to obtain valid VPG setting identifier
if ($ValidVPGSettingsIdentifier -eq $true)
{
$VPGSettingsURL = $baseURL+”vpgSettings/”+$VPGSettingsIdentifier
$VPGSettings = Invoke-RestMethod -Uri $VPGSettingsURL -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting recovery site ID (needed anyway for network settings)
$VPGRecoverySiteIdentifier = $VPGSettings.Basic.RecoverySiteIdentifier
# Getting site info
$VISitesURL = $baseURL+”virtualizationsites”
$VISitesCMD = Invoke-RestMethod -Uri $VISitesURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting network info
$VINetworksURL = $baseURL+”virtualizationsites/$VPGRecoverySiteIdentifier/networks”
$VINetworksCMD = Invoke-RestMethod -Uri $VINetworksURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting datastore info
$VIDatastoresURL = $baseURL+”virtualizationsites/$VPGRecoverySiteIdentifier/datastores”
$VIDatastoresCMD = Invoke-RestMethod -Uri $VIDatastoresURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting datastore cluster info
$VIDatastoreClustersURL = $baseURL+”virtualizationsites/$VPGRecoverySiteIdentifier/datastoreclusters”
$VIDatastoreClustersCMD = Invoke-RestMethod -Uri $VIDatastoreClustersURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting folder info
$VIFoldersURL = $baseURL+”virtualizationsites/$VPGRecoverySiteIdentifier/folders”
$VIFoldersCMD = Invoke-RestMethod -Uri $VIFoldersURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting cluster info
$VIClustersURL = $baseURL+”virtualizationsites/$VPGRecoverySiteIdentifier/hostclusters”
$VIClustersCMD = Invoke-RestMethod -Uri $VIClustersURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting host info
$VIHostsURL = $baseURL+”virtualizationsites/$VPGRecoverySiteIdentifier/hosts”
$VIHostsCMD = Invoke-RestMethod -Uri $VIHostsURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting resource pool info
$VIResourcePoolsURL = $baseURL+”virtualizationsites/$VPGRecoverySiteIdentifier/resourcepools”
$VIResourcePoolsCMD = Invoke-RestMethod -Uri $VIResourcePoolsURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting all VPG Settings
$VPGJournalHistoryInHours = $VPGSettings.Basic.JournalHistoryInHours
$VPGName = $VPGSettings.Basic.Name
$VPGPriortiy = $VPGSettings.Basic.Priority
$VPGProtectedSiteIdentifier = $VPGSettings.Basic.ProtectedSiteIdentifier
$VPGRpoInSeconds = $VPGSettings.Basic.RpoInSeconds
$VPGServiceProfileIdentifier = $VPGSettings.Basic.ServiceProfileIdentifier
$VPGTestIntervalInMinutes = $VPGSettings.Basic.TestIntervalInMinutes
$VPGUseWanCompression = $VPGSettings.Basic.UseWanCompression
$VPGZorgIdentifier = $VPGSettings.Basic.ZorgIdentifier
# Getting Boot Group IDs
$VPGBootGroups = $VPGSettings.BootGroups.BootGroups
$VPGBootGroupCount = $VPGSettings.BootGroups.BootGroups.Count
$VPGBootGroupNames = $VPGSettings.BootGroups.BootGroups.Name
$VPGBootGroupDelays = $VPGSettings.BootGroups.BootGroups.BootDelayInSeconds
$VPGBootGroupIdentifiers = $VPGSettings.BootGroups.BootGroups.BootGroupIdentifier
# Getting Journal info
$VPGJournalDatastoreClusterIdentifier = $VPGSettings.Journal.DatastoreClusterIdentifier
$VPGJournalDatastoreIdentifier = $VPGSettings.Journal.DatastoreIdentifier
$VPGJournalHardLimitInMB = $VPGSettings.Journal.Limitation.HardLimitInMB
$VPGJournalHardLimitInPercent = $VPGSettings.Journal.Limitation.HardLimitInPercent
$VPGJournalWarningThresholdInMB = $VPGSettings.Journal.Limitation.WarningThresholdInMB
$VPGJournalWarningThresholdInPercent = $VPGSettings.Journal.Limitation.WarningThresholdInPercent
# Getting Network IDs
$VPGFailoverNetworkID = $VPGSettings.Networks.Failover.Hypervisor.DefaultNetworkIdentifier
$VPGFailoverTestNetworkID = $VPGSettings.Networks.FailoverTest.Hypervisor.DefaultNetworkIdentifier
# Getting recovery info
$VPGDefaultDatastoreIdentifier = $VPGSettings.Recovery.DefaultDatastoreIdentifier
$VPGDefaultFolderIdentifier = $VPGSettings.Recovery.DefaultFolderIdentifier
$VPGDefaultHostClusterIdentifier = $VPGSettings.Recovery.DefaultHostClusterIdentifier
$VPGDefaultHostIdentifier = $VPGSettings.Recovery.DefaultHostIdentifier
$VPGResourcePoolIdentifier = $VPGSettings.Recovery.ResourcePoolIdentifier
# Getting scripting info
$VPGScriptingPreRecovery = $VPGSettings.Scripting.PreRecovery
$VPGScriptingPostRecovery = $VPGSettings.Scripting.PostRecovery
# Getting VM IDs in VPG
$VPGVMIdentifiers = $VPGSettings.VMs.VmIdentifier
################################################
# Translating Zerto IDs from VPG settings to friendly vSphere names
################################################
# Getting site names
$VPGProtectedSiteName = $VISitesCMD | Where-Object {$_.SiteIdentifier -eq $VPGProtectedSiteIdentifier} | select -ExpandProperty VirtualizationSiteName
$VPGRecoverySiteName = $VISitesCMD | Where-Object {$_.SiteIdentifier -eq $VPGRecoverySiteIdentifier} | select -ExpandProperty VirtualizationSiteName
# Getting network names
$VPGFailoverNetworkName = $VINetworksCMD | Where-Object {$_.NetworkIdentifier -eq $VPGFailoverNetworkID} | Select -ExpandProperty VirtualizationNetworkName
$VPGFailoverTestNetworkName = $VINetworksCMD | Where-Object {$_.NetworkIdentifier -eq $VPGFailoverTestNetworkID} | Select -ExpandProperty VirtualizationNetworkName
# Getting datastore cluster name
$VPGJournalDatastoreClusterName = $VIDatastoreClustersCMD | Where-Object {$_.DatastoreClusterIdentifier -eq $VPGJournalDatastoreClusterIdentifier} | select -ExpandProperty DatastoreClusterName
# Getting datastore names
$VPGDefaultDatastoreName = $VIDatastoresCMD | Where-Object {$_.DatastoreIdentifier -eq $VPGDefaultDatastoreIdentifier} | select -ExpandProperty DatastoreName
$VPGJournalDatastoreName = $VIDatastoresCMD | Where-Object {$_.DatastoreIdentifier -eq $VPGJournalDatastoreIdentifier} | select -ExpandProperty DatastoreName
# Getting folder name
$VPGDefaultFolderName = $VIFoldersCMD | Where-Object {$_.FolderIdentifier -eq $VPGDefaultFolderIdentifier} | select -ExpandProperty FolderName
# Getting cluster name
$VPGDefaultHostClusterName = $VIClustersCMD | Where-Object {$_.ClusterIdentifier -eq $VPGDefaultHostClusterIdentifier} | select -ExpandProperty VirtualizationClusterName
# Getting host name
$VPGDefaultHostName = $VIHostsCMD | Where-Object {$_.HostIdentifier -eq $VPGDefaultHostIdentifier} | select -ExpandProperty VirtualizationHostName
# Getting resource pool name
$VPGResourcePoolName = $VIResourcePoolsCMD | Where-Object {$_.ResourcePoolIdentifier -eq $VPGResourcePoolIdentifier} | select -ExpandProperty ResourcepoolName
################################################
# Adding all VPG setting info to $VPGArray
################################################
$VPGArrayLine = new-object PSObject
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGName” -Value $VPGName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGidentifier” -Value $VPGidentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGOrganization” -Value $VPGOrganization
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGVMCount” -Value $VPGVMCount
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGPriortiy” -Value $VPGPriortiy
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGProtectedSiteName” -Value $VPGProtectedSiteName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGProtectedSiteIdentifier” -Value $VPGProtectedSiteIdentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGRecoverySiteName” -Value $VPGRecoverySiteName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGRecoverySiteIdentifier” -Value $VPGRecoverySiteIdentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGRpoInSeconds” -Value $VPGRpoInSeconds
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGServiceProfileIdentifier” -Value $VPGServiceProfileIdentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGTestIntervalInMinutes” -Value $VPGTestIntervalInMinutes
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGUseWanCompression” -Value $VPGUseWanCompression
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGZorgIdentifier” -Value $VPGZorgIdentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGBootGroupCount” -Value $VPGBootGroupCount
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGBootGroupNames” -Value $VPGBootGroupNames
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGBootGroupDelays” -Value $VPGBootGroupDelays
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGBootGroupIdentifiers” -Value $VPGBootGroupIdentifiers
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGJournalHistoryInHours” -Value $VPGJournalHistoryInHours
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGJournalDatastoreClusterName” -Value $VPGJournalDatastoreClusterName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGJournalDatastoreClusterIdentifier” -Value $VPGJournalDatastoreClusterIdentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGJournalDatastoreName” -Value $VPGJournalDatastoreName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGJournalDatastoreIdentifier” -Value $VPGJournalDatastoreIdentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGJournalHardLimitInMB” -Value $VPGJournalHardLimitInMB
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGJournalHardLimitInPercent” -Value $VPGJournalHardLimitInPercent
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGJournalWarningThresholdInMB” -Value $VPGJournalWarningThresholdInMB
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGJournalWarningThresholdInPercent” -Value $VPGJournalWarningThresholdInPercent
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGFailoverNetworkName” -Value $VPGFailoverNetworkName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGFailoverNetworkID” -Value $VPGFailoverNetworkID
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGFailoverTestNetworkName” -Value $VPGFailoverTestNetworkName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGFailoverTestNetworkID” -Value $VPGFailoverTestNetworkID
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGDefaultDatastoreName” -Value $VPGDefaultDatastoreName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGDefaultDatastoreIdentifier” -Value $VPGDefaultDatastoreIdentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGDefaultFolderName” -Value $VPGDefaultFolderName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGDefaultFolderIdentifier” -Value $VPGDefaultFolderIdentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGDefaultHostClusterName” -Value $VPGDefaultHostClusterName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGDefaultHostClusterIdentifier” -Value $VPGDefaultHostClusterIdentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGDefaultHostName” -Value $VPGDefaultHostName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGDefaultHostIdentifier” -Value $VPGDefaultHostIdentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGResourcePoolName” -Value $VPGResourcePoolName
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGResourcePoolIdentifier” -Value $VPGResourcePoolIdentifier
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGScriptingPreRecovery” -Value $VPGScriptingPreRecovery
$VPGArrayLine | Add-Member -MemberType NoteProperty -Name “VPGScriptingPostRecovery” -Value $VPGScriptingPostRecovery
$VPGArray += $VPGArrayLine
################################################
# Starting for each VM ID action for collecting ZVM VM data
################################################
foreach ($_ in $VPGVMIdentifiers)
{
$VMIdentifier = $_
# Get VMs settings
$GetVMSettingsURL = $baseURL+”vpgSettings/”+$VPGSettingsIdentifier+”/vms/”+$VMIdentifier
$GetVMSettings = Invoke-RestMethod -Method Get -Uri $GetVMSettingsURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting the VM name and disk usage
$VMNameArray = $vmListarray | where-object {$_.VmIdentifier -eq $VMIdentifier} | Select-Object *
$VMName = $VMNameArray.VmName
$VMProvisionedStorageInMB = $VMNameArray.ProvisionedStorageInMB
$VMUsedStorageInMB = $VMNameArray.UsedStorageInMB
# Setting variables from the API
$VMVolumeCount = $GetVMSettings.Volumes.Count
$VMNICCount = $GetVMSettings.Nics.Count
$VMBootGroupIdentifier = $GetVMSettings.BootGroupIdentifier
$VMJournalDatastoreClusterIdentifier = $GetVMSettings.Journal.DatastoreClusterIdentifier
$VMJournalDatastoreIdentifier = $GetVMSettings.Journal.DatastoreIdentifier
$VMJournalHardLimitInMB = $GetVMSettings.Journal.Limitation.HardLimitInMB
$VMJournalHardLimitInPercent = $GetVMSettings.Journal.Limitation.HardLimitInPercent
$VMJournalWarningThresholdInMB = $GetVMSettings.Journal.Limitation.WarningThresholdInMB
$VMJournalWarningThresholdInPercent = $GetVMSettings.Journal.Limitation.WarningThresholdInPercent
$VMDatastoreClusterIdentifier = $GetVMSettings.Recovery.DatastoreClusterIdentifier
$VMDatastoreIdentifier = $GetVMSettings.Recovery.DatastoreIdentifier
$VMFolderIdentifier = $GetVMSettings.Recovery.FolderIdentifier
$VMHostClusterIdentifier = $GetVMSettings.Recovery.HostClusterIdentifier
$VMHostIdentifier = $GetVMSettings.Recovery.HostIdentifier
$VMResourcePoolIdentifier = $GetVMSettings.Recovery.ResourcePoolIdentifier
################################################
# Translating Zerto IDs from VM settings to friendly vSphere names
################################################
# Getting boot group
$VMBootGroupName = $VPGBootGroups | Where-Object {$_.BootGroupIdentifier -eq $VMBootGroupIdentifier} | select -ExpandProperty Name
$VMBootGroupDelay = $VPGBootGroups | Where-Object {$_.BootGroupIdentifier -eq $VMBootGroupIdentifier} | select -ExpandProperty BootDelayInSeconds
# Getting datastore cluster name
$VMJournalDatastoreClusterName = $VIDatastoreClustersCMD | Where-Object {$_.DatastoreClusterIdentifier -eq $VMJournalDatastoreClusterIdentifier} | select -ExpandProperty DatastoreClusterName
$VMDatastoreClusterName = $VIDatastoreClustersCMD | Where-Object {$_.DatastoreClusterIdentifier -eq $VMDatastoreClusterIdentifier} | select -ExpandProperty DatastoreClusterName
# Getting datastore name
$VMJournalDatastoreName = $VIDatastoresCMD | Where-Object {$_.DatastoreIdentifier -eq $VMJournalDatastoreIdentifier} | select -ExpandProperty DatastoreName
$VMDatastoreName = $VIDatastoresCMD | Where-Object {$_.DatastoreIdentifier -eq $VMDatastoreIdentifier} | select -ExpandProperty DatastoreName
# Getting folder name
$VMFolderName = $VIFoldersCMD | Where-Object {$_.FolderIdentifier -eq $VMFolderIdentifier} | select -ExpandProperty FolderName
# Getting cluster name
$VMHostClusterName = $VIClustersCMD | Where-Object {$_.ClusterIdentifier -eq $VMHostClusterIdentifier} | select -ExpandProperty VirtualizationClusterName
# Getting host name
$VMHostName = $VIHostsCMD | Where-Object {$_.HostIdentifier -eq $VMHostIdentifier} | select -ExpandProperty VirtualizationHostName
# Getting resource pool name
$VMResourcePoolName = $VIResourcePoolsCMD | Where-Object {$_.ResourcePoolIdentifier -eq $VMResourcePoolIdentifier} | select -ExpandProperty ResourcepoolName
################################################
# Adding all VM setting info to $VMArray
################################################
$VMArrayLine = new-object PSObject
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VPGName” -Value $VPGName
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VPGidentifier” -Value $VPGidentifier
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMName” -Value $VMName
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMIdentifier” -Value $VMIdentifier
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICCount” -Value $VMNICCount
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMVolumeCount” -Value $VMVolumeCount
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMProvisionedStorageInMB” -Value $VMProvisionedStorageInMB
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMUsedStorageInMB” -Value $VMUsedStorageInMB
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMBootGroupName” -Value $VMBootGroupName
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMBootGroupDelay” -Value $VMBootGroupDelay
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMBootGroupIdentifier” -Value $VMBootGroupIdentifier
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMJournalDatastoreClusterName” -Value $VMJournalDatastoreClusterName
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMJournalDatastoreClusterIdentifier” -Value $VMJournalDatastoreClusterIdentifier
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMJournalDatastoreName” -Value $VMJournalDatastoreName
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMJournalDatastoreIdentifier” -Value $VMJournalDatastoreIdentifier
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMJournalHardLimitInMB” -Value $VMJournalHardLimitInMB
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMJournalHardLimitInPercent” -Value $VMJournalHardLimitInPercent
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMDatastoreClusterName” -Value $VMDatastoreClusterName
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMDatastoreClusterIdentifier” -Value $VMDatastoreClusterIdentifier
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMDatastoreName” -Value $VMDatastoreName
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMDatastoreIdentifier” -Value $VMDatastoreIdentifier
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMFolderName” -Value $VMFolderName
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMFolderIdentifier” -Value $VMFolderIdentifier
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMHostClusterName” -Value $VMHostClusterName
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMHostClusterIdentifier” -Value $VMHostClusterIdentifier
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMHostName” -Value $VMHostName
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMHostIdentifier” -Value $VMHostIdentifier
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMResourcePoolName” -Value $VMResourcePoolName
$VMArrayLine | Add-Member -MemberType NoteProperty -Name “VMResourcePoolIdentifier” -Value $VMResourcePoolIdentifier
$VMArray += $VMArrayLine
################################################
# Get VM Volume settings for the current VPG
################################################
$GetVMSettingVolumesURL = $baseURL+”vpgSettings/”+$VPGSettingsIdentifier+”/vms/”+$VMIdentifier+”/volumes”
$GetVMSettingVolumes = Invoke-RestMethod -Method Get -Uri $GetVMSettingVolumesURL -TimeoutSec 100 -Headers $zertoSessionHeader_XML -ContentType $TypeXML
$GetVMSettingVolumeIDs = $GetVMSettingVolumes.ArrayOfVpgSettingsVmVolumeApi.VpgSettingsVmVolumeApi | select-object VolumeIdentifier -ExpandProperty VolumeIdentifier
################################################
# Starting for each VM Volume ID action for collecting ZVM VM Volume data
################################################
foreach ($_ in $GetVMSettingVolumeIDs)
{
$VMVolumeID = $_
# Getting API data for volume
$GetVMSettingVolumeURL = $baseURL+”vpgSettings/”+$VPGSettingsIdentifier+”/vms/”+$VMIdentifier+”/volumes/”+$VMVolumeID
$GetVMSettingVolume = Invoke-RestMethod -Method Get -Uri $GetVMSettingVolumeURL -TimeoutSec 100 -Headers $zertoSessionHeader_XML -ContentType $TypeXML
# Setting values
$VMVolumeDatastoreClusterIdentifier = $GetVMSettingVolume.VpgSettingsVmVolumeApi.Datastore.DatastoreClusterIdentifier
$VMVolumeDatastoreIdentifier = $GetVMSettingVolume.VpgSettingsVmVolumeApi.Datastore.DatastoreIdentifier
$VMVolumeIsSWAP = $GetVMSettingVolume.VpgSettingsVmVolumeApi.IsSwap
$VMVolumeIsThin = $GetVMSettingVolume.VpgSettingsVmVolumeApi.Datastore.IsThin
# Getting datastore cluster name
$VMVolumeDatastoreClusterName = $VIDatastoreClustersCMD | Where-Object {$_.DatastoreClusterIdentifier -eq $VMVolumeDatastoreClusterIdentifier} | select -ExpandProperty DatastoreClusterName
# Getting datastore name
$VMVolumeDatastoreName = $VIDatastoresCMD | Where-Object {$_.DatastoreIdentifier -eq $VMVolumeDatastoreIdentifier} | select -ExpandProperty DatastoreName
################################################
# Adding all VM Volume setting info to $VMVolumeArray
################################################
$VMVolumeArrayLine = new-object PSObject
$VMVolumeArrayLine | Add-Member -MemberType NoteProperty -Name “VPGName” -Value $VPGName
$VMVolumeArrayLine | Add-Member -MemberType NoteProperty -Name “VPGidentifier” -Value $VPGidentifier
$VMVolumeArrayLine | Add-Member -MemberType NoteProperty -Name “VMName” -Value $VMName
$VMVolumeArrayLine | Add-Member -MemberType NoteProperty -Name “VMIdentifier” -Value $VMIdentifier
$VMVolumeArrayLine | Add-Member -MemberType NoteProperty -Name “VMVolumeID” -Value $VMVolumeID
$VMVolumeArrayLine | Add-Member -MemberType NoteProperty -Name “VMVolumeIsSWAP” -Value $VMVolumeIsSWAP
$VMVolumeArrayLine | Add-Member -MemberType NoteProperty -Name “VMVolumeIsThin” -Value $VMVolumeIsThin
$VMVolumeArrayLine | Add-Member -MemberType NoteProperty -Name “VMVolumeDatastoreClusterName” -Value $VMVolumeDatastoreClusterName
$VMVolumeArrayLine | Add-Member -MemberType NoteProperty -Name “VMVolumeDatastoreClusterIdentifier” -Value $VMVolumeDatastoreClusterIdentifier
$VMVolumeArrayLine | Add-Member -MemberType NoteProperty -Name “VMVolumeDatastoreName” -Value $VMVolumeDatastoreName
$VMVolumeArrayLine | Add-Member -MemberType NoteProperty -Name “VMVolumeDatastoreIdentifier” -Value $VMVolumeDatastoreIdentifier
$VMVolumeArray += $VMVolumeArrayLine
}
################################################
# Get VM Nic settings for the current VPG
################################################
$GetVMSettingNICsURL = $baseURL+”vpgSettings/”+$VPGSettingsIdentifier+”/vms/”+$VMIdentifier+”/nics”
$GetVMSettingNICs = Invoke-RestMethod -Method Get -Uri $GetVMSettingNICsURL -TimeoutSec 100 -Headers $zertoSessionHeader_XML -ContentType $TypeXML
$VMNICIDs = $GetVMSettingNICs.ArrayOfVpgSettingsVmNicApi.VpgSettingsVmNicApi | select-object NicIdentifier -ExpandProperty NicIdentifier
################################################
# Starting for each VM NIC ID action for collecting ZVM VM NIC data
################################################
foreach ($_ in $VMNICIDs)
{
$VMNICIdentifier = $_
$GetVMSettingNICURL = $baseURL+”vpgSettings/”+$VPGSettingsIdentifier+”/vms/”+$VMIdentifier+”/nics/”+$VMNICIdentifier
$GetVMSettingNIC = Invoke-RestMethod -Method Get -Uri $GetVMSettingNICURL -TimeoutSec 100 -Headers $zertoSessionHeader_XML -ContentType $TypeXML
# Building arrays
$VMSettingNICIDArray1 = $GetVMSettingNIC.VpgSettingsVmNicApi.Failover.Hypervisor
$VMSettingNICIDArray2 = $GetVMSettingNIC.VpgSettingsVmNicApi.Failover.Hypervisor.IpConfig
$VMSettingNICIDArray3 = $GetVMSettingNIC.VpgSettingsVmNicApi.FailoverTest.Hypervisor
$VMSettingNICIDArray4 = $GetVMSettingNIC.VpgSettingsVmNicApi.FailoverTest.Hypervisor.IpConfig
# Setting failover values
$VMNICFailoverDNSSuffix = $VMSettingNICIDArray1.DnsSuffix
$VMNICFailoverNetworkIdentifier = $VMSettingNICIDArray1.NetworkIdentifier
$VMNICFailoverShouldReplaceMacAddress = $VMSettingNICIDArray1.ShouldReplaceMacAddress
$VMNICFailoverGateway = $VMSettingNICIDArray2.Gateway
$VMNIsFailoverDHCP = $VMSettingNICIDArray2.IsDhcp
$VMNICFailoverPrimaryDns = $VMSettingNICIDArray2.PrimaryDns
$VMNICFailoverSecondaryDns = $VMSettingNICIDArray2.SecondaryDns
$VMNICFailoverStaticIp = $VMSettingNICIDArray2.StaticIp
$VMNICFailoverSubnetMask = $VMSettingNICIDArray2.SubnetMask
# Nulling blank content
if ($VMNICFailoverDNSSuffix.nil -eq $true){$VMNICFailoverDNSSuffix = $null}
if ($VMNICFailoverGateway.nil -eq $true){$VMNICFailoverGateway = $null}
if ($VMNICFailoverPrimaryDns.nil -eq $true){$VMNICFailoverPrimaryDns = $null}
if ($VMNICFailoverSecondaryDns.nil -eq $true){$VMNICFailoverSecondaryDns = $null}
if ($VMNICFailoverStaticIp.nil -eq $true){$VMNICFailoverStaticIp = $null}
if ($VMNICFailoverSubnetMask.nil -eq $true){$VMNICFailoverSubnetMask = $null}
# Setting failover test values
$VMNICFailoverTestDNSSuffix = $VMSettingNICIDArray3.DnsSuffix
$VMNICFailoverTestNetworkIdentifier = $VMSettingNICIDArray3.NetworkIdentifier
$VMNICFailoverTestShouldReplaceMacAddress = $VMSettingNICIDArray3.ShouldReplaceMacAddress
$VMNICFailoverTestGateway = $VMSettingNICIDArray4.Gateway
$VMNIsFailoverTestDHCP = $VMSettingNICIDArray4.IsDhcp
$VMNICFailoverTestPrimaryDns = $VMSettingNICIDArray4.PrimaryDns
$VMNICFailoverTestSecondaryDns = $VMSettingNICIDArray4.SecondaryDns
$VMNICFailoverTestStaticIp = $VMSettingNICIDArray4.StaticIp
$VMNICFailoverTestSubnetMask = $VMSettingNICIDArray4.SubnetMask
# Nulling blank content
if ($VMNICFailoverTestDNSSuffix.nil -eq $true){$VMNICFailoverTestDNSSuffix = $null}
if ($VMNICFailoverTestGateway.nil -eq $true){$VMNICFailoverTestGateway = $null}
if ($VMNICFailoverTestPrimaryDns.nil -eq $true){$VMNICFailoverTestPrimaryDns = $null}
if ($VMNICFailoverTestSecondaryDns.nil -eq $true){$VMNICFailoverTestSecondaryDns = $null}
if ($VMNICFailoverTestStaticIp.nil -eq $true){$VMNICFailoverTestStaticIp = $null}
if ($VMNICFailoverTestSubnetMask.nil -eq $true){$VMNICFailoverTestSubnetMask = $null}
# Mapping Network IDs to Names
$VMNICFailoverNetworkName = $VINetworksCMD | Where-Object {$_.NetworkIdentifier -eq $VMNICFailoverNetworkIdentifier} | Select VirtualizationNetworkName -ExpandProperty VirtualizationNetworkName
$VMNICFailoverTestNetworkName = $VINetworksCMD | Where-Object {$_.NetworkIdentifier -eq $VMNICFailoverTestNetworkIdentifier} | Select VirtualizationNetworkName -ExpandProperty VirtualizationNetworkName
################################################
# Adding all VM NIC setting info to $VMNICArray
################################################
$VMNICArrayLine = new-object PSObject
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VPGName” -Value $VPGName
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VPGidentifier” -Value $VPGidentifier
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMName” -Value $VMName
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMIdentifier” -Value $VMIdentifier
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICIdentifier” -Value $VMNICIdentifier
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverNetworkName” -Value $VMNICFailoverNetworkName
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverNetworkIdentifier” -Value $VMNICFailoverNetworkIdentifier
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverDNSSuffix” -Value $VMNICFailoverDNSSuffix
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverShouldReplaceMacAddress” -Value $VMNICFailoverShouldReplaceMacAddress
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverGateway” -Value $VMNICFailoverGateway
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverDHCP” -Value $VMNIsFailoverDHCP
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverPrimaryDns” -Value $VMNICFailoverPrimaryDns
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverSecondaryDns” -Value $VMNICFailoverSecondaryDns
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverStaticIp” -Value $VMNICFailoverStaticIp
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverSubnetMask” -Value $VMNICFailoverSubnetMask
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverTestNetworkName” -Value $VMNICFailoverTestNetworkName
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverTestNetworkIdentifier” -Value $VMNICFailoverTestNetworkIdentifier
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverTestDNSSuffix” -Value $VMNICFailoverTestDNSSuffix
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverTestShouldReplaceMacAddress” -Value $VMNICFailoverTestShouldReplaceMacAddress
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverTestGateway” -Value $VMNICFailoverTestGateway
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverTestDHCP” -Value $VMNIsFailoverTestDHCP
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverTestPrimaryDns” -Value $VMNICFailoverTestPrimaryDns
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverTestSecondaryDns” -Value $VMNICFailoverTestSecondaryDns
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverTestStaticIp” -Value $VMNICFailoverTestStaticIp
$VMNICArrayLine | Add-Member -MemberType NoteProperty -Name “VMNICFailoverTestSubnetMask” -Value $VMNICFailoverTestSubnetMask
$VMNICArray += $VMNICArrayLine
# End of per VM NIC actions below
}
# End of per VM NIC actions above
#
# End of per VM actions below
}
# End of per VM actions above
################################################
# Deleting VPG edit settings ID (same as closing the edit screen on a VPG in the ZVM without making any changes)
################################################
Try
{
Invoke-RestMethod -Method Delete -Uri $VPGSettingsURL -TimeoutSec 100 -Headers $zertoSessionHeader_XML -ContentType $TypeXML
}
Catch [system.exception] {
}
#
# End of check for valid VPG settings ID below
}
# End of check for valid VPG settings ID above
#
# End of per VPG actions below
}
# End of per VPG actions above
#
################################################
# Showing Results – edit here for export commands etc
################################################
write-host “VPG Array:”
$VPGArray | fl
write-host “VM Array:”
$VMArray | fl
write-host “VM VOlume Array:”
$VMVolumeArray | fl
write-host “VM NIC Array:”
$VMNICArray | fl
# Exporting results
# Exporting arrays to CSV
$VPGArray | export-csv $ExportDataDir”VPGArray.csv” -NoTypeInformation
$VMArray | export-csv $ExportDataDir”VMArray.csv” -NoTypeInformation
$VMVolumeArray | export-csv $ExportDataDir”VMVolumeArray.csv” -NoTypeInformation
$VMNICArray | export-csv $ExportDataDir”VMNICArray.csv” -NoTypeInformation

Sean B
February 14, 2018 09:02:54 PM

Thanks Ron!!!
Julian M
August 30, 2021 05:22:55 AM
Thanks Ron, it would have been a long-winded exercise trying to replace all the quote characters from the original PDF.

One problem with the code, and this has nothing to do with the changes you made to get it to work, is that for virtuals which are replicated to multiple destinations, the data for a few properties in the VMArray.CSV shows as “System.Object[]”. What I found is that there are multiple properties for the variable and when an object variable is exported to CSV, it is entered as “System.Object[]” in the file.

The reason this is happening is when we look at this part of the code:
```
##########################################
# Starting for each VM ID action for collecting ZVM VM data
################################################
foreach ($_ in $VPGVMIdentifiers)
{
$VMIdentifier = $_
# Get VMs settings
$GetVMSettingsURL = $baseURL+”vpgSettings/”+$VPGSettingsIdentifier+”/vms/”+$VMIdentifier
$GetVMSettings = Invoke-RestMethod -Method Get -Uri $GetVMSettingsURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting the VM name and disk usage
$VMNameArray = $vmListarray | where-object {$_.VmIdentifier -eq $VMIdentifier} | Select-Object *
$VMName = $VMNameArray.VmName
```
The code loops through each VPG, notes the VMIdentifier then asks for the settings from Zerto using the Invoke-RestMethod. Since the virtual server is present in multiple replication destinations, instead of one text value being retrieved, an object is received with as many properties as the virtual machine has replication destinations.

My trick is to only retrieve the first of the multiple properties retrieved, and this is how i did it:

Affected properties in VMArray report:

VMName
VMProvisionedStorageInMB
VMUsedStorageInMB

Here’s the code I modified:
```
##########################################
# Starting for each VM ID action for collecting ZVM VM data
################################################
foreach ($_ in $VPGVMIdentifiers)
{
$VMIdentifier = $_
# Get VMs settings
$GetVMSettingsURL = $baseURL+”vpgSettings/”+$VPGSettingsIdentifier+”/vms/”+$VMIdentifier
$GetVMSettings = Invoke-RestMethod -Method Get -Uri $GetVMSettingsURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting the VM name and disk usage
$VMNameArray = $vmListarray | where-object {$_.VmIdentifier -eq $VMIdentifier} | Select-Object *
$VMName = $VMNameArray.VmName[0]
$VMProvisionedStorageInMB = $VMNameArray.ProvisionedStorageInMB[0]
$VMUsedStorageInMB = $VMNameArray.UsedStorageInMB[0]
```
I hope this helps.
Julian M
August 30, 2021 05:49:29 AM
The code I posted above sadly now fails with virtuals which only have one property value, however it seems that this modification only fixes the issue:
```
##########################################
# Starting for each VM ID action for collecting ZVM VM data
################################################
foreach ($_ in $VPGVMIdentifiers)
{
$VMIdentifier = $_
# Get VMs settings
$GetVMSettingsURL = $baseURL+”vpgSettings/”+$VPGSettingsIdentifier+”/vms/”+$VMIdentifier
$GetVMSettings = Invoke-RestMethod -Method Get -Uri $GetVMSettingsURL -TimeoutSec 100 -Headers $zertoSessionHeader_JSON -ContentType $TypeJSON
# Getting the VM name and disk usage
$VMNameArray = $vmListarray | where-object {$_.VmIdentifier -eq $VMIdentifier} | Select-Object -first 1
$VMName = $VMNameArray.VmName
```
I replaced “Select-Object *” with “Select-Object -first 1” and it seems to be working OK.

The forum ‘General Discussion’ is closed to new topics and replies.