- This topic has 2 replies, 3 voices, and was last updated May 1, 2020 by
kfunderburk@m3comva.com.
Getting Site VMs info using PowerShell a script
-
Kenneth FApril 8, 2020 02:58:12 PM
I am new to PowerShell and am not sure where to start. But my question is. Is there a script that can be run to pull/export to excel, just the VM information per site?
I would like to do a weekly audit of the number of VMs my customers have weekly.
Scott GApril 11, 2020 02:44:40 AMWe use something like this:
function getxZertoSession ($zvm, $userName, $password) {
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
$xZertoSessionURL = $zvm + "session/add"
$authInfo = ("{0}:{1}" -f $userName, $password)
$authInfo = [System.Text.Encoding]::UTF8.GetBytes($authInfo)
$authInfo = [System.Convert]::ToBase64String($authInfo)
$headers = @{Authorization = ("Basic {0}" -f $authInfo) }
$body = '{"AuthenticationMethod": "1"}'
$contentType = "application/json"
$xZertoSessionResponse = Invoke-WebRequest -Uri $xZertoSessionURL -Headers $headers -Method POST -Body $body -ContentType $contentType
return @{"x-zerto-session" = $xZertoSessionResponse.headers.get_item("x-zerto-session") }
}# Initializations
$ZVMServer = "myserver.mydomain.local:9669"
$ZertoRestURL = "https://$($ZVMServer)/v1/"$ZertoVMs = @()
$VPGSettingsCollection = @()# Get Credentials for ZVM API
$Credentials = Get-Credential -Message "Please enter Username and Password for ZVM $($ZVMServer)" -UserName "$($env:USERNAME)"
$username = $Credentials.UserName
$password = $Credentials.GetNetworkCredential().Password# Get Zerto Session Header for Auth
$ZertoSession = getxZertoSession "$($ZertoRestURL)" $username $password# Connect to vCenter
Connect-VIServer 'myvcenter' -Credential $Credentials# Get all the VPGs and store in $VPGSettingsCollection
$AllVPGs = Invoke-RestMethod -Method Get -Uri ("$($ZertoRestURL)VPGs") -ContentType "application/json" -Headers $ZertoSession
foreach ($VPG in $AllVPGs) {
$VPG_Id = '{"VpgIdentifier": "' + $VPG.VpgIdentifier + '"}'
$VPGsettingsObject = Invoke-RestMethod -Method POST -Uri ("$($ZertoRestURL)VPGSettings") -ContentType "application/json" -Body $VPG_Id -Headers $ZertoSession
$VPGsettingsObject$VPGSettings = Invoke-RestMethod -Method GET -Uri ("$($ZertoRestURL)VPGSettings/$($VPGsettingsObject)") -ContentType "application/json" -Headers $ZertoSession
Invoke-RestMethod -Method DELETE -Uri ("$($ZertoRestURL)VPGSettings/$($VPGsettingsObject)") -ContentType "application/json" -Headers $ZertoSession
$VPGSettingsCollection += $VPGsettings
}# Get all the running VMs from VMware, excluding the VRAs themselves
$VMwareVMs = Get-Datacenter 'MyDatacenter' | Get-Cluster | Get-Vm | Where { $_.PowerState -eq 'PoweredOn' -and $_.Name -notlike "Z-VRA-*" }# Start building array $ZertoVMs from relevant items in $VPGSettingsCollection
ForEach ($VPG in $VPGSettingsCollection) {
ForEach ($VM in $VPG.Vms) {
$VmInfo = "" | Select Name, FailoverIP, VPG
$Id = "VirtualMachine-" + $VM.VmIdentifier.Split('.')[1] $VMInfo.Name = ($VMwareVMs | Where { $_.Id -eq $Id }).Name
$VMInfo.FailoverIP = $VM.Nics[0].Failover.Hypervisor.IpConfig.StaticIp
$VMInfo.VPG = $VPG.basic.name
$ZertoVMs += $VMInfo
}
}$ZertoVMs | Export-Csv "MyZertoVMs.csv"