= Script: PowerCLI: Create CSV with VMInfo

**Summary**: A script to collect all sorts of data from VMs \\
**Date**: Around 2013 \\
**Refactor**: 22 March 2025: Checked links and formatting. \\
{{tag>powershell vmware}}

This is a [[vspherepowercli|powershell/powercli]] script which retracts all kind of VM Info and puts that in a csv file. \\
Retracted info includes:
* Regular information like VM name and hostname
* Extended network information like all IP addresses and in the case of multiple NICs all MAC addresses, nic types and network names
* CPU information
* Memory information
* Guest information including the Installed OS and Running OS (if different this could have [[http://frankdenneman.nl/2009/12/impact-of-mismatch-guest-os-type/|impact]] )
* VMWare tools information
* The host the VM runs on

== Script ==

<code powershell>
$timestamp = Get-Date -format "yyyyMMdd-HH.mm"

# $csvFile = Read-Host "Enter csv file"
$csvfile = "C:\$timestamp-vminfo.csv"

# $vCenter = "vCenter"
# Connect-VIServer $vCenter

$myCol = @()

# All VMs
# foreach ($VM in (Get-VM)){
# Folder
# foreach ($VM in (get-folder testfolder | get-vm )){
# Host
# foreach ($vm in (get-vmhost testhost.domain | get-vm )){
# Test one VM
foreach ($VM in (Get-VM WINXP-TESTVM)){

# All VMs
# foreach ($VM in (Get-VM)){
# Test one VM
# foreach ($VM in (Get-VM ROAPRDT301)){
# Folder
# foreach ($VM in (get-folder Frankfurt | get-vm )){
# Host
foreach ($vm in (get-vmhost esxprd101.intranet | get-vm )){

$vmnic = Get-NetworkAdapter -VM $VM
$vmview = Get-VM $VM | Get-View
# Below is the original command that gave the working command I need to get all MacAddresses
# Get-VM | Select-Object -Property Name,@{N="MacAdresses";E={$_.NetworkAdapters | ForEach-Object {$_.MacAddress}}},VMHost
# Get output without headers: | format-wide -column 1
$nicmac = Get-NetworkAdapter -VM $VM | ForEach-Object {$_.MacAddress}
$nictype = Get-NetworkAdapter -VM $VM | ForEach-Object {$_.Type}
$nicname = Get-NetworkAdapter -VM $VM | ForEach-Object {$_.NetworkName}
# Get multiple scsi adapters
$scsiname = Get-ScsiController -VM $VM | Foreach-Object {$_.Name}
$scsitype = Get-ScsiController -VM $VM | Foreach-Object {$_.Type}
# If GuestOS is Windows XP or Windows Server 2003 it's possible to get the network information from the Guest itself
# To make this work you need credentials for the guest
while ($credentials -eq $null) {
  Write-Host (get-date -uformat %I:%M:%S) "Please provide authentication credentials for VM Guest Operating System(s)" -ForegroundColor Green;
  #$credentials = Get-Credential -Credential ""
  $credentials = $Host.UI.PromptForCredential("Please enter credentials", "Enter Guest credentials", "Administrator", "")
}

$VMInfo = "" |select-Object VMName,VMHostName,NICCount,IPAddress,MacAddress,NICType,NetworkName,SCSIControllers,SCSIType,CPUReservation,CPULimit,CPUShares,NumCPU,MEMSize,MEMReservation,MEMLimit,MEMShares,GuestFamily,GuestSelectedOS,GuestRunningOS,PowerState,ToolsVersion,ToolsStatus,ToolsRunningStatus,HWLevel,VMHost,GuestIPpolicy,GuestIP,GuestSubnetMask,GuestDefaultGateway,GuestDNSPolicy,GuestDNSServers
$VMInfo.VMName = $vmview.Name
$VMInfo.VMHostName = $vmview.Guest.HostName
$VMInfo.NICCount = $vmview.Guest.Net.Count
$VMInfo.IPAddress = [String]$VM.Guest.IPAddress
# If you need the IPaddresses specifically specified you can use this:
#$VMInfo.IPAddress1 = $VM.Guest.IPAddress[0]
#$VMInfo.IPAddress2 = $VM.Guest.IPAddress[1]
#$VMInfo.IPAddress3 = $VM.Guest.IPAddress[2]
$VMInfo.MacAddress = [String]$nicmac
$VMInfo.NICType = [String]$nictype
$VMInfo.NetworkName = [String]$nicname
# This options shows the connection state of the NIC. Uncomment if needed.
#$VMInfo.NICState = $vmnic.ConnectionState.Connected
$VMInfo.SCSIControllers = [String]$scsiname
$VMInfo.SCSIType = [String]$scsitype
$VMInfo.CPUReservation = $vmview.Config.CpuAllocation.Reservation
If ($vmview.Config.CpuAllocation.Limit-eq "-1"){
   $VMInfo.CPULimit = "Unlimited"}
Else{
   $VMInfo.CPULimit = $vmview.Config.CpuAllocation.Limit
}
$VMInfo.CPUShares = $vmview.Config.CpuAllocation.Shares.Shares
$VMInfo.NumCPU = $VM.NumCPU
$VMInfo.MEMSize = $vmview.Config.Hardware.MemoryMB
$VMInfo.MEMReservation = $vmview.Config.MemoryAllocation.Reservation
If ($vmview.Config.MemoryAllocation.Limit-eq "-1"){
   $VMInfo.MEMLimit = "Unlimited"}
Else{
   $VMInfo.MEMLimit = $vmview.Config.MemoryAllocation.Limit
}
$VMInfo.MEMShares = $vmview.Config.MemoryAllocation.Shares.Shares
$VMInfo.GuestFamily = $vmview.Guest.GuestFamily
$VMInfo.GuestSelectedOS = $vmview.Summary.Config.GuestFullName
$VMInfo.GuestRunningOS = $vmview.Guest.GuestFullname
$VMInfo.PowerState = $VM.PowerState
$VMInfo.ToolsVersion = $vmview.Guest.ToolsVersion
$VMInfo.ToolsStatus = $vmview.Guest.ToolsStatus
$VMInfo.ToolsRunningStatus = $vmview.Guest.ToolsRunningStatus
$VMInfo.HWLevel = $vmview.Config.Version
$VMInfo.VMHost = $VM.VMHost
if (($VMInfo.GuestRunningOS -match "2003") -or ($VMInfo.GuestRunningOS -match "XP") -and ($VMInfo.PowerState -eq "PoweredOn") -and ($VMInfo.ToolsStatus -eq "ToolsOK")){
  $GuestInterface = Get-VMGuestNetworkInterface -VM $VM -GuestCredential $credentials;
  $VMInfo.GuestIPpolicy = $GuestInterface.IPPolicy;
  $VMInfo.GuestIP = $GuestInterface.Ip;
  $VMInfo.GuestSubnetMask = $GuestInterface.SubnetMask;
  $VMInfo.GuestDefaultGateway = $GuestInterface.DefaultGateway;
  $VMInfo.GuestDNSPolicy = $GuestInterface.DnsPolicy;
  $VMInfo.GuestDNSServers = [string]$GuestInterface.Dns
}
else{
  $VMInfo.GuestIPpolicy = "Not available for this Guest OS, PowerState or ToolsStatus"
}

$myCol += $VMInfo
}

$myCol |Export-csv -NoTypeInformation $csvfile

# Disconnect-VIServer -Confirm:$false
</code>

= Useful Links =

http://www.simple-talk.com/sysadmin/virtualization/10-steps-to-kick-start-your-vmware-automation-with-powercli/ \\
http://technet.microsoft.com/en-us/library/ee692801.aspx \\
http://technet.microsoft.com/en-us/library/ee176845.aspx \\
http://stam.blogs.com/8bits/2010/05/arrays-in-powershell.html \\
http://frankdenneman.nl/2009/12/impact-of-mismatch-guest-os-type/ \\

//This wiki has been made possible by://

<HTML>
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-8613096447910897"
     crossorigin="anonymous"></script>
<!-- Wiki End of Page -->
<ins class="adsbygoogle"
     style="display:block"
     data-ad-client="ca-pub-8613096447910897"
     data-ad-slot="6221699236"
     data-ad-format="auto"
     data-full-width-responsive="true"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script>
</HTML>