Hi everyone,
I need your suggestions. I have a script that reports me daily about new VMs and their details. now I want to extend this script and want to add 2 more Row (cluster and Folder). I tried myself but nothing came out.
these 2 rows should contain this info:
1: Folder name(if possible with path)
2: Cluster name.
my Script:
$report = [System.Collections.ArrayList]@()
$view = Get-View -ViewType Virtualmachine
$cnt = 1
Write-Host "Found $($view.count) virtual machines"
$events = Get-VIEvent -Entity $view.Name -MaxSamples ([int]::MaxValue) |
Where-Object { $_ -is [VMware.Vim.VmDeployedEvent] -or
$_ -is [VMware.Vim.VmClonedEvent]-or
$_ -is [VMware.Vim.VmCreatedEvent]-or
$_ -is [VMware.Vim.VmPoweredOffEvent]-or
$_ -is [VMware.Vim.VmRegisteredEvent]}
Write-Host "Found $($view.count) virtual machines"
foreach($vm in $view ) {
if (!$vm.Config) { continue }
Write-Host "Processing $($cnt) - $($vm.Name)"
$vms = [PSCustomObject]@{
VMName = $vm.Name
Responsible_Team = ""
Hostname = $vm.guest.hostname
OS = $vm.Config.GuestFullName
IPAddress = $vm.guest.ipAddress
Boottime = $vm.Runtime.BootTime
# PoweredOff = ($events | where{$_.VM.Name -eq $vm.Name} | Sort-Object -Property CreatedTime -Descending | Select -First 1).CreatedTime -replace '(\d+:\d+):\d+'
VMState = $vm.summary.runtime.powerState
UsedSpaceGB = [math]::Round($vm.Summary.Storage.Committed/1GB,2)
ProvisionedSpaceGB = [math]::Round(($vm.Summary.Storage.Committed + $vm.Summary.Storage.UnCommitted)/1GB,2)
MemoryUsage = $vm.summary.quickStats.guestMemoryUsage
Datastore = $vm.Config.DatastoreUrl[0].Name
CreatedDate = $vm.Config.CreateDate
Unit = ""
Notes = $vm.Config.Annotation -replace '(?:\r|\n)',''
ToolsStatus = $vm.guest.toolsstatus
ToolsVersion = $vm.config.tools.toolsversion
Folder = ""
Cluster = ""
}
foreach ($c in $vm.CustomValue) {
switch ($c.Key) {
"901" { $vms.Unit = $c.Value }
}
}
$Report.Add($vms) | Out-Null
$cnt++
}
