Saturday, 4 February 2017

Virtual Machines name, snapshot name, and snapshot descriptions export to CSV file –VMware vSphere PowerCLI

Or, Virtual Machines snapshot report export to csv file using VMware vSphere PowerCLI.
Or, Finding Virtual Machines with snapshot details using VMware vSphere PowerCLI.
Or, vSphere PowerCLI command to get VMs list with snapshot name and descriptions.

Descriptions: Remember the storage optimization task?, the very first thing we do is we check for the VMs having snapshot. Sometime we end up with having few VMs with very large snapshot data size.

If you have 10-20 VMs, its easy for you to check each VMs individually to see which are the VMs having snapshot but what if you have 100 or 1000 VMs?? Its not possible or even not a wise decision to check each and every VMs individually for this reason.

Therefore, here you have some cool stuffs to do in vSphere PowerCLI. Just few sequential command arrangements and you are done. You can have the list of VMs having snapshot on the CLI dashboard or you can choose to export the list of such VMs in CSV file.…

Steps: Connecting vCenter Server with vSphere Power CLI
Open vSphere PowerCLI > Type the command below and hit enter

Connect-VIServer IPAddressOfvCenterServer












Enter the vCenter Server credentials and say OK (in my case the user name is ‘administrator@vsphere.local)’





















Steps: Getting VMs list with snapshot details on vSphere CLI dashboard
Once you connected successfully with your vCenter server, type the command below and hit enter. Now you will have the VMs List, Snapshot Name Details, and Snapshots Descriptions details as highlighted in below screenshot.

Get-VM | Get-Snapshot | select VM, Name, Description













Steps: Exporting VMs list report with snapshot details in CSV file
To export the VMs list with snapshot details in a CSV file, type the below command and hit enter

Get-VM | Get-Snapshot | select VM, Name, Description | Export-Csv D:\temp\testreport.csv






Note: Please change the Export CSV path to your preferred folder path.

Upon successful completion of the command, you would be having csv report details like below:





Updated 4th Feb 2017
You can try few more commands as given below for detailed report:

To get VM list with VM Name, Snapshot Name, Snapshot Description, Snapshot Creation Date
Get-VM | Get-Snapshot | select VM, Name, Description, Created

To get VM list with VM Name, Snapshot Name, Snapshot Description, Snapshot Creation Date, Snapshot Size in GB
Get-VM | Get-Snapshot | select VM, Name, Description, Created, SizeGB

Cheers, please write me back if you have any query or feedback.

No comments:

Post a Comment