Hi all,<\/p>\n
In this blog I will explain an easy way to generate a Virtual Machine inventory\u00a0and export it to\u00a0a csv file. We will be using the \u201cGet-VM\u201d cmdlet and piping it to the \u201cExport-csv\u201d cmdlet to get the information we need in the examples below. To do anything with PowerShell in VMware you will need to install VMware vSphere PowerCLI. You will then need to open PowerCLI connect to your VMWare vCenter server by typing \u201cConnect-VIServer vCenterServerName\u201d.<\/p>\n
The simplest way to get a VM inventory with lots of useful information is to type the following command replacing the path with the directory and file name you would like to use.<\/p>\n
Get-VM | Export-Csv -path “c:\\reports\\vminventory.csv<\/em>” \u2013NoTypeInformation<\/p>\n The command above will dump a list of your VMs to a csv file containing the following fields:<\/p>\n PowerState, Version, Description, Notes, Guest, NumCpu, MemoryMB, MemoryGB, HardDisks, NetworkAdapters, UsbDevices, CDDrives, FloppyDrives, Host, HostId, VMHostId, VMHost, VApp, FolderId, Folder, ResourcePoolId, ResourcePool, PersistentId, UsedSpaceGB, ProvisionedSpaceGB, DatastoreIdList, HARestartPriority, HAIsolationResponse, DrsAutomationLevel, VMSwapfilePolicy, VMResourceConfiguration, Name, CustomFields, ExtensionData, Id, Uid, Client<\/p>\n Now let\u2019s say this you didn\u2019t need this much information in your report. You could type the following command to get the output with only the fields you need. In the following example we will only export the Name, Description, PowerState, NumCpu and MemoryGB fields.<\/p>\n Get-VM | select Name, Description, PowerState, NumCpu, MemoryGB | Export-Csv -path “c:\\reports\\vminventory.csv<\/em>” -NoTypeInformation<\/p>\n If you needed to sort the spreadsheet by one of the fields for example the \u201cName\u201d field, you can type the following command:<\/p>\n Get-VM | select Name, Description, PowerState, NumCpu, MemoryGB | sort Name | Export-Csv -path “c:\\reports\\vminventory.csv<\/em>” \u2013NoTypeInformation<\/p>\n The example above will create a csv with the Name, Description, PowerState, NumCpu and MemoryGB fields and sort the list by Name in alphabetical order.<\/p>\n I hope this helps. As always, if you have any questions or feedback, please leave a comment.<\/p>\n Related Links:<\/p>\n Using PowerShell to get a list Virtual Machine Snapshots in VMware ESXi 4.1<\/a><\/strong><\/p>\n Using PowerShell to Gracefully Shut Down Multiple Virtual Machines in VMware<\/strong><\/a><\/p>\n Using PowerShell to Remove Virtual Machine Snapshots in VMware ESXi 4.1<\/b><\/a><\/p>\n Using PowerShell to View Datastore and Virtual Machine Space Usage Information in VMware<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" Hi all, In this blog I will explain an easy way to generate a Virtual Machine inventory\u00a0and export it to\u00a0a csv file. We will be using the \u201cGet-VM\u201d cmdlet and piping it to the \u201cExport-csv\u201d cmdlet to get the information … Continue reading