Get VM inventory

spiceuser-9q9iv · 2021-12-16T14:04:18.000Z

Hello

Can someone write me a Powershell script. I have a list of servers (text file) running on vCenter and I want to collect their IP, MAC, vLAN, OS, vmtools, Mem, CPU, and disk usage info in a csv file. I do not know Powershell very well and struggling to come up with a script to accomplish this. Any help would be greatly appreciated

Thanks

Neally · 2021-12-16T14:30:44.000Z

Welcome.

Did you do some research?

What have you tried? Where are you stuck?

Have you installed powerCli and connected to your vecenter?

VMware PowerCLI Blog – 5 Mar 13

Back to Basics: Connecting to vCenter or a vSphere Host

Following my previous post which took you through the install of PowerCLI I thought it was time to add another back to basics (B2B) post and show how to take the first step in using PowerCLI… Connecting to your vCenter or vSphere host. Yes, PowerCLI...

Est. reading time: 5 minutes

We’re happy to help but a script writing service.

If you have some actual code and you’re stuck, feel free to post and we’ll try to help from there

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

192033ab-bb8f-4032-88a5-8e2313af0344-codebutton_small.png

Neally Bot

spiceuser-9q9iv · 2021-12-17T15:30:52.000Z

Yes, I have the following working script. Only need to add OS, vmtools, MAC, and vLAN info. Thanks

Script

===========================

Connect-VIServer X.X.X.X
$VMs = Get-VM (Get-Content vms.txt)
$Output = foreach ($VM in $VMs){
Get-VM $VM | select Name, @{N=”FolderName”;E={ $.Folder.Name}}, NumCpu, MemoryGB, @{N=”CPUUsage”;E={ $.ExtensionData.Summary.QuickStats.OverallCpuUsage}}, @{N=”MemoryUsage”;E={$.ExtensionData.Summary.QuickStats.GuestMemoryUsage}}, ProvisionedSpaceGB, UsedSpaceGB, PowerState, VMHost, @{N=”Datastore”;E={$.ExtensionData.Config.DatastoreUrl.Name}}, @{N=”Network”;E={$.Guest.Nics[0]}}, @{N=”IPAddress”;E={$.Guest.IPAddress[0]}}, @{N=”DNSName”;E={$_.ExtensionData.Guest.Hostname}}
}
$Output | Export-Csv C:\Temp\Result.csv -NoTypeInformation

===================

Neally · 2021-12-17T16:03:04.000Z

Why post a new topic?

Get Detailed VM Info Programming & Development

Hello All I have the following working scrip to gather vm detailed info from vCenter. Can someone help me add the following info in the script OS, vmtools, MAC, vLAN Thank you so much. Below is the script =========================== Connect-VIServer X.X.X.X $VMs = Get-VM (Get-Content vms.txt) $Output = foreach ($VM in $VMs){ Get-VM $VM | select Name, @{N=”FolderName”;E={ $.Folder.Name}}, NumCpu, MemoryGB, @{N=”CPUUsage”;E={ $.ExtensionData.Summary.QuickStats.OverallCpuUsage}}, @{N…

Neally · 2021-12-17T16:26:09.000Z

You just add what you need t that query

e.g. os might be this

@{n='OS';e={($_ | get-view).config.guestfullname}}

and you have to figure out the rest

spiceuser-9q9iv · 2021-12-17T17:29:15.000Z

Thanks. I got the other ones but I could not figure out how to get vLAN info

spiceuser-9q9iv · 2021-12-17T18:06:32.000Z

I got the script going but it does not generate the MAC and Subnet. It just leaves the columns blank in the csv file. Any help to fix this would be greatly appreciated. Thanks

==========================

Connect-VIServer x.x.x.x
$VMs = Get-VM (Get-Content c:\temp\computers.txt)
$Output = foreach ($VM in $VMs){
Get-VM $VM | select Name,
@{N=”FolderName”;E={ $.Folder.Name}}, NumCpu, MemoryGB,
@{N=”CPUUsage”;E={ $.ExtensionData.Summary.QuickStats.OverallCpuUsage}},
@{N=”MemoryUsage”;E={$.ExtensionData.Summary.QuickStats.GuestMemoryUsage}}, ProvisionedSpaceGB, UsedSpaceGB, PowerState, VMHost,
@{N=”Datastore”;E={$.ExtensionData.Config.DatastoreUrl.Name}},
@{N=”Network”;E={$.Guest.Nics[0]}},
@{N=”IPAddress”;E={$.Guest.IPAddress[0]}},
@{N=”DNSName”;E={$.ExtensionData.Guest.Hostname}},
@{N=”OS”;E={($ | get-view).config.guestfullname}},
@{N=‘VLAN’;E={[string]::Join(‘,’,(Get-NetworkAdapter -Vm $vm | Select-Object -ExpandProperty NetworkName))}},
@{N=‘Tools’;E={$vm.ExtensionData.Guest.ToolsRunningStatus}},
@{N=‘Gateway’;E={[string]::Join(‘,’,($vm.ExtensionData.Guest.IpStack.IpRouteConfig.IpRoute | %{if($.Gateway.IpAddress){$.Gateway.IpAddress}}))}},
@{N=‘Subnet Mask’;E={

$dec = [Convert]::ToUInt32($((‘1’ * $_.IpConfig.IpAddress[0].PrefixLength).PadRight(32, ‘0’)), 2)

$DottedIP = $( For ($i = 3; $i -gt -1; $i–) {

$Remainder = $dec % [Math]::Pow(256, $i)

( $dec - $Remainder) / [Math]::Pow(256, $i)

$dec = $Remainder

} )

[String]::Join(‘.’, $DottedIP)

}},

@{N=“DNS”;E={[string]::Join(‘,’,($vm.ExtensionData.Guest.IpStack.DnsConfig.IpAddress))}},

@{N=‘MAC’;E={[string]::Join(‘,’,$_.MacAddress)}}
}
$Output | Export-Csv C:\Temp\Result.csv -NoTypeInformation

=============