Powershell Scritp for Inventory VMS in Hyper-V and VMware

 Today I have to create a list of VMS, but with specific information.

Usually you will like some basic info from your virtual machines, including, name, amoutn of CPU, RAM and Disk Usage.

Seems simple, but the true is a nightmare. The issue is about the Disk usage. When your VMs has only one disk is easy, but what about a machine with 4 disks? What if these disk are thin provisioning and you need to sum the space?

Well... here you will learn how, and using simple lines.


Get a List of VMS from Virtual Machine Manager

If using VMM you can use this method, this will allow a complete list of all hosts and VMS in your environment.

#This get the list of all VMs

$vms = Get-VM -All

#this generate a report including, name, host, status, cpu, ram and disk usage

$Report = $vms | select name, vmhost, status, CPUcount, MemoryAssignedMB, @{Name="DiskAllocated";Expression={[math]::round($_.TotalSize/1024/1024/1024,2)}}

#this export the report as CSV. Now you can take this to Excel.

$Report | Export-CSV -NoTypeInformation -Encoding UTF8 -Path c:\tools\Reporte_VMS.csv

The trick is using a calculated parameter. TotalSize has the Value, I changed the name to "Disk Allocated" and changed the result from bytes to Gigabytes.



Get the List from VMware Powershell CLI

the following will work if you have downloaded and installed the Powershell CLI for vmware.

#First, connecto to your vcenter Server

Connect-VIServer -Server vcenter02.example.com

#Get the list of VMs stored in a variable

$vms2=get-vm

#Get the holy-script to get the used disk of your VM

$Report= $vms2 | select name,Host,PowerState,NumCpu,MemoryGB, @{Name="DiskAllocated";Expression={$_.extensiondata.Storage.PerDatastoreUsage | foreach {$z=$null}{$z+=$_.Committed}{[math]::round($z/1GB,2)}}}

#Esport the results to a CSV file.

$Report | Export-CSV -NoTypeInformation -Encoding UTF8 -Path c:\tools\Reporte_VMS.csv


In this last example, the issue is a little more difficult. As you don't have a value for Total Size, you have to iterate in your VM and get a property called "Committed", but this is stored in your $VM.extensiondata.Storage.PerDatastoreUsage. The issue is when you have multiple disks and this is tored in different datastores. This script sums the values using a variable named "$z"

foreach {$z=$null}{$z+=$_.Committed}{$z}

In order to give this a format, I change to GB and get only 2 decimals:

[math]::round($z/1GB,2)

see you, have a nice scripting.

Comments

Post a Comment

Popular posts from this blog

Update DNS static servers in your local Network

Image
 lets say you need to update your DNS servers, maybe you installed a new Domain Controller in your network. So probably the last step is update in each computer the primary and secondary DNS server. It's sad, but in GPO, you will not find an effective way of doing this for windows10 Instead, you can use this script. $inet1=Get-DnsClient  | Get-DnsClientServerAddress | where{$_.ServerAddresses -contains "192.168.0.245" -or $_.ServerAddresses -contains "192.168.0.207"} foreach($nic in $inet1){     Set-DnsClientServerAddress -InterfaceIndex $nic.InterfaceIndex -ServerAddresses ("192.168.0.245","192.168.0.114") } You can change the old IPs (192.168.0.245 and 192.168.0.207) for new IPs. then, save the file as ChangeDNS.ps1 file in your network Share. Create a New GPO and configure the Schedule Tasks for the Computer node. Configure the task as Immediate Task. Set the user account as SYSTEM. It will automatically convert into NT Authority\system. S
Read more

Error 'General access denied error' (0x80070005). Starting SCVMM Resource

Image
 Hello,  After a VMM migration and disk migration I faced this issue. I was unable to start a VM. So if you check on Failover Cluster Manager, you should find this information under "roles". If you check information, it says you should get more information from the "Information Details" windows. This example error says about an Access denied error, so this should be related to permisions. In fact, I did a change on my VMs disk, that is probably the cause on my case.  For resolving I recommend, checking on permissions on the disks of your VM, and if possible, use a tool to copy/paste the correct permissions. Luckly in my case, I do have another disk with the correct permissions, so I used icacls to backup and restore the correct permissions. icacls VM1_mydisk.vhdx /save backup.txt then, you should open the backup.txt file and change the name of the file, to match the destination. then restore using: icacls C:\ClusterStorage\Volume3\VM1 /restore backup.txt After doing
Read more