I have about six scripts currently that pull this data and then that many Perl scripts to parse and put all of the data into one CSV file. Needless to say it is a bit of a mess. If I can pull all of the data I need in one script it will eliminate a lot of parsing errors. Thanks.
$vmware_uuid,$vm_name,$vcenter_server,$vm_ip,$vm_os,$rp,$ram,$cpu,$hd,$vmt_status,$powerstate,$datastore,$numsnaps,$sizesnaps,$utilization
UUID:
Get-VM | select @{N="VMname"; E={$_.Name}},
@{N="UUID"; E={($_ | Get-View).config.uuid}} | Export-Csv $filename1 -noTypeInformation
VM Name, OS, IP:
Get-VM | %{
$guest = $_ | Get-VMGuest
$vm = "" | Select VMname, OSFullName, IPAddr1
$vm.VMname = $_.Name
$vm.OSFullName = $guest.OSFullname
if ($vm.OSFullName -eq "Microsoft Windows Server 2003, Enterprise Edition (32-bit)" ) {
$vm.OSFullName = "Microsoft Windows Server 2003 Enterprise Edition (32-bit)"}
elseif ($vm.OSFullName -eq "Microsoft Windows Server 2003, Enterprise Edition (64-bit)" ) {
$vm.OSFullName = "Microsoft Windows Server 2003 Enterprise Edition (64-bit)"}
elseif ($vm.OSFullName -eq "Microsoft Windows Server 2003, Standard Edition (32-bit)" ) {
$vm.OSFullName = "Microsoft Windows Server 2003 Standard Edition (32-bit)"}
elseif ($vm.OSFullName -eq "Microsoft Windows Server 2003, Standard Edition (64-bit)" ) {
$vm.OSFullName = "Microsoft Windows Server 2003 Standard Edition (64-bit)"}
$vm.IPAddr1 = $guest.IPAddress[0]
$vm
} | Export-Csv "$filename1" -noTypeInformation
Specs:
$VMs = Get-VM
$myCol = @()
ForEach ($VM in $VMs)
{
$myObj = "" | Select-Object VMName, DisksGB
$myObj.VMName = $VM.Name
$myObj.DisksGB = [Math]::Round((($VM.HardDisks | Measure-Object -Property CapacityKB -Sum).Sum * 1KB / 1GB),2)
$myCol += $myObj
#$myCol
}
$myCol | Export-Csv "$filename1" -NoTypeInformation
$Report = @()
get-vm | % {
$vm = Get-View $_.ID
$vms = "" | Select-Object VMName, VMState, TotalCPU, TotalMemory, ToolsStatus, resourcepool, Datastore
$vms.VMName = $vm.Name
$vms.VMState = $vm.summary.runtime.powerState
$vms.TotalCPU = $vm.summary.config.numcpu
$vms.TotalMemory = $vm.summary.config.memorysizemb
$vms.ToolsStatus = $vm.guest.toolsstatus
$resourcepool = Get-ResourcePool -VM $vms.VMName
$vms.resourcepool = $resourcepool.Name
$Report += $vms
#$Report
}
$Report | Export-Csv "$filename2" -noTypeInformation
$report = @()
Get-VM | Get-View | % {
$row = "" | select Name, Datastore
$row.Name = $_.Name
$row.Datastore = (Get-View $_.Datastore[0]).Summary.Name
$report += $row
}
$report | Export-Csv "$filename3" -noTypeInformation
Snapshots:
$DiskInfoDef = @"
public struct DiskInfo {
public string VMname;
public string TotalSnapMB;
"@
# Original
#$vms = Get-View -ViewType VirtualMachine
# New
$vms = Get-View -ViewType VirtualMachine -Property "LayoutEx", "Snapshot", "Config.Hardware.Device", "Name"
$maxSnapshot = ($vms | %{$_.LayoutEx.Snapshot.Count} | Measure-Object -Maximum).Maximum
1..$maxSnapshot | %{
$DiskInfoDef += ("`n`tpublic string Snap" + $_ + "MB;")
}
$DiskInfoDef += "`n}"
Add-Type -Language CsharpVersion3 -TypeDefinition $DiskInfoDef
$snapHash = @{}
filter Get-SnapHash{
$snapHash[$_.Snapshot.Value] = $_.Name
if($_.ChildSnapshotList){
$_.ChildSnapShotList | Get-SnapHash
}
}
$vms | %{
$vm = $_
if($vm.Snapshot){
$vm.Snapshot.RootSnapshotList | Get-SnapHash
}
$_.Config.Hardware.Device | where {$_.DeviceInfo.Label -like "Hard disk *"} | %{
$hd = $_
$vm.LayoutEx.Disk | where {$_.Key -eq $hd.Key} | %{
$diskFiles = $_.Chain | %{$_.FileKey} | %{$_}
}
$diskInfo = New-Object DiskInfo
$diskInfo.VMname = $vm.Name
$snapNr = 1
if($vm.Snapshot){
$totalSnapMB = 0
$vm.LayoutEx.Snapshot | %{
$_.Disk | where {$_.Key -eq $hd.Key} | %{
$prevFiles = $_.Chain | %{$_.FileKey} | %{$_}
}
$vm.LayoutEx.Disk | where {$_.Key -eq $hd.Key} | %{
foreach($chain in $_.Chain){
if($prevFiles -notcontains $chain.FileKey[0] -and $prevFiles -notcontains $chain.FileKey[1]){
break
}
}
}
$snapFiles = $chain.FileKey | %{$_}
$snapSize = ""
if($snapFiles){
$snapAllocated = 0
$vm.LayoutEx.File | where {$snapFiles -contains $_.Key} | %{
$snapAllocated += $_.Size
}
$snapSize = ("{0:N1}" -f ($snapAllocated / 1MB))
}
$diskInfo.("Snap" + $snapNr + "MB") = $snapSize
$totalSnapMB += ($snapAllocated / 1MB)
$snapNr++
}
$totalSnapMB = ($totalSnapMB/1024)
$diskInfo.TotalSnapMB = ("{0:N1}" -f $totalSnapMB)
}
$diskInfo
}
} | Export-Csv $filename1 -UseCulture -NoTypeInformation
