$VC = Connect-VIServer localhost -Protocol https -User administrator -Password "#############"
## Our VMFS datastores use a standard naming convention. This differentiates them from local storage and
## templates. Change the -Name parameter to match your naming conventions
$VMFS = Get-Datastore -refresh -Name "LUN???" | Sort-Object $_.Name
$report = @() # blank data structure
$allvms = Get-Datacenter "Datacenter" | Get-VM | Sort-Object $_.Name # I likes to sorts my datas
foreach ($vm in $allvms) {
$vmview = $vm | Get-View # get-view to see details of the FM
foreach($disk in $vmview.Storage.PerDatastoreUsage){ # Disks for the VM
$dsview = (Get-View $disk.Datastore) # Datastore used by the disks
$dsview.RefreshDatastoreStorageInfo() # refresh to get the latest data
$vmview.Config.Name # Echo to the screen to show progress
$row = "" | select VMNAME, DATASTORE, VMSIZE_MB, VMUSED_MB, PERCENT # blank row
$row.VMNAME = $vmview.Config.Name # Add the data to the row
$row.DATASTORE = $dsview.Name
$row.VMSIZE_MB = (($disk.Committed+$disk.Uncommitted)/1024/1024)
$row.VMUSED_MB = (($disk.Committed)/1024/1024)
$row.PERCENT = [int](($row.VMUSED_MB / $row.VMSIZE_MB)*100)
$report += $row # Add the row to the structure
}
}
$report | Export-Csv "C:\temp\vm_dss.csv" -NoTypeInformation # dump the report to .csv
$DSReport = @() # blank data structure for datastore information
foreach ($LUN in $VMFS) {
$VMSizeSum = 0 # We will sum the data from the previous report for this LUN
$LUN.Name # Echo to screen to show progress.
foreach ($row in $report) { # Generate sum for this LUN
if ($row.DATASTORE -eq $LUN.Name) {$VMSizeSum += $row.VMSIZE_MB}
}
# Create a blank row and add data to it.
$DSRow = "" | select Datastore_Name,Capacity_MB, FreeSpace_MB, Allocated_MB, Unallocated_MB
$DSRow.Datastore_Name = $LUN.Name
$DSRow.Capacity_MB = $LUN.CapacityMB
$DSRow.FreeSpace_MB = $LUN.FreeSpaceMB
$DSRow.Allocated_MB = [int]$VMSizeSum
$DSRow.Unallocated_MB = $LUN.CapacityMB - [int]$VMSizeSum # NB that if we have overallocated disk # space this will be a negative number
$DSReport += $DSRow # add the row to the structure.
}
$DSReport | Export-Csv "C:\temp\Datastores.csv" -NoTypeInformation # dump report to .csv
Get-View : 24/04/2014 9:54:14 AM Get-View Permission to perform this operation was denied. Required privilege 'System.Read' on managed object with id 'Datastore-datastore-14109'.
At C:\scripts\storage.ps1:23 char:33
+ $dsview = (Get-View <<<< $disk.Datastore) # Datastore used by the disks
+ CategoryInfo : NotSpecified: (:) [Get-View], NoPermission
+ FullyQualifiedErrorId : Client20_MoServiceImpl_GetNetInteropView_ViError,VMware.VimAutomation.ViCore.Cmdlets.Commands.DotNetInterop.GetVIView
Get-View : 24/04/2014 9:54:14 AM Get-View View with Id 'Datastore-datastore-14109' was not found on the server(s).
At C:\scripts\storage.ps1:23 char:33
+ $dsview = (Get-View <<<< $disk.Datastore) # Datastore used by the disks
+ CategoryInfo : ObjectNotFound: (:) [Get-View], VimException
+ FullyQualifiedErrorId : Core_GetView_WriteNotFoundError,VMware.VimAutomation.ViCore.Cmdlets.Commands.DotNetInterop.GetVIView
You cannot call a method on a null-valued expression.
At C:\scripts\storage.ps1:24 char:46
I am running the latest PowerCLI, and am logging in as administrator with full rights
