{"id":1228,"date":"2023-10-29T00:09:00","date_gmt":"2023-10-29T00:09:00","guid":{"rendered":"https:\/\/labiol.xyz\/?p=1228"},"modified":"2024-01-19T05:42:02","modified_gmt":"2024-01-19T05:42:02","slug":"powershell-scripts-to-help-you-out-with-detailed-disk-storage-calculations","status":"publish","type":"post","link":"https:\/\/www.labiol.xyz\/index.php\/2023\/10\/29\/powershell-scripts-to-help-you-out-with-detailed-disk-storage-calculations\/","title":{"rendered":"PowerShell scripts to help you out with detailed disk\/storage calculations."},"content":{"rendered":"\n

Please use all scripts published by me with caution. The scripts have been tested in my environment and are functional, but I do not take responsibility for how they may behave in your environment.<\/mark><\/p>\n\n\n\n

Scirpt to calculate disk number:<\/p>\n\n\n\n

$vmsall = get-vm | where {$_.powerstate -like "PoweredOn"}. ## for all VMs defined here\n$vmdisks = @()\nforeach ($vv in $vmsall){\n  $diskforvm = New-Object -TypeName psobject\n  $diskforvm | Add-Member -MemberType NoteProperty -name "name"-value $vv.name\n  $diskforvm | Add-Member -MemberType NoteProperty -name "disk_number" -value (($vv | get-view).layoutex.disk.key).count\n  $vmdisks += $diskforvm\n}\n$vmdisks | Sort-Object -Property disk_number<\/code><\/pre><\/div>\n\n\n\n
Script to check various disk parameters:<\/p>\n\n\n\n
#vms contains the list of VMs that we want to work on \n\nforeach ($vm in $vms){\n  Write-Host "checking:" + $vm\n  if (-not (get-vm $vm)){\n    $vm | out-file -Append desktop\\disk-size-scope-21062023-notfound.txt}\n  else{\n    get-vm $vm | select name, @{n="UsedSpaceGB"; e={[Math]::Ceiling($_.UsedSpaceGB)}},@{n="ProvisionedSpaceGB"; e={[Math]::Ceiling($_.ProvisionedSpaceGB)}}, @{n="DiskSize"; e={(Get-HardDisk -VM $_ | Measure-Object -Sum CapacityGB).Sum}}, @{n="RealUsage"; e={[Math]::Ceiling(((($_ | get-view).guest.disk.Capacity | Measure-Object -Sum).sum \/ 1GB) - ((($_ | get-view).guest.disk.freespace | measure-object -sum).sum \/ 1GB))}}, memorygb, @{n="ClusterName"; e={(Get-Cluster -vm $_).name}}, @{n="CPU"; e={cpunum}} | Export-Csv -Append -Path desktop\\disk-size-scope-21062023.csv }\n }<\/code><\/pre><\/div>\n\n\n\n
Script to check Physical or Virtual (Bus Sharing Mode) – indicating RDM:<\/p>\n\n\n\n
#vms contains the list of VMs that we want to work on \n\n$array = @()\nforeach ($vm in $vms){\n     $vm = get-vm $vm\n     $disks = $vm | Get-ScsiController | Where-Object {$_.BusSharingMode -eq 'Physical'  -or $_.BusSharingMode -eq 'Virtual'}\n     foreach ($disk in $disks){\n         $REPORT = New-Object -TypeName PSObject\n         $REPORT | Add-Member -type NoteProperty -name Name -Value $vm.Name\n         $REPORT | Add-Member -type NoteProperty -name VMHost -Value $vm.Host\n         $REPORT | Add-Member -type NoteProperty -name Mode -Value $disk.BusSharingMode\n         $REPORT | Add-Member -type NoteProperty -name Type -Value 'BusSharing'\n         $REPORT | Add-Member -type NoteProperty -name UsedSpacegB -Value [Math]::Ceiling($vm.UsedSpaceGB)\n         $array += $REPORT\n      }\n     }<\/code><\/pre><\/div>\n\n\n\n
Similar script but returning more information:<\/p>\n\n\n\n
$array = @()\nforeach ($vmka in $vms){\n  $vmka = get-vm -name $vmka\n  $REPORT = New-Object -TypeName PSObject\n  $REPORT | Add-Member -type NoteProperty -name Name -Value $vmka.name\n  $REPORT | Add-Member -type NoteProperty -name noSharingControlerNum -Value ($vmka |Get-ScsiController | where {$_.BusSharingMode -like "NoSharing"}).count\n  $REPORT | Add-Member -type NoteProperty -name SharedControlerNum -Value ($vmka |Get-ScsiController | where {$_.BusSharingMode -eq 'Physical'  -or $_.BusSharingMode -eq 'Virtual'}).count\n  #hack with -join, otherwise it is not possible to export to csv\n  $noShareDisks = (Get-HardDisk -VM $vmka | where {$_.extensiondata.controllerkey -in ($vmka |Get-ScsiController | where {$_.BusSharingMode -like "NoSharing"}).key}).Filename -join ", "\n  $REPORT | Add-Member -type NoteProperty -name noSharedDisks -Value $noShareDisks\n  $sharedDisks = (Get-HardDisk -VM $vmka | where {$_.extensiondata.controllerkey -in ($vmka |Get-ScsiController | where {$_.BusSharingMode -like 'Physical'  -or $_.BusSharingMode -like 'Virtual'}).key}).Filename -join ", "\n  $REPORT | Add-Member -type NoteProperty -name SharedDisks -Value $sharedDisks\n  \n  $noShareDisksNum = (Get-HardDisk -VM $vmka | where {$_.extensiondata.controllerkey -in ($vmka |Get-ScsiController | where {$_.BusSharingMode -like "NoSharing"}).key}).count\n  $REPORT | Add-Member -type NoteProperty -name noSharedDisksNum -Value $noShareDisksNum\n  $sharedDisksNum = (Get-HardDisk -VM $vmka | where {$_.extensiondata.controllerkey -in ($vmka |Get-ScsiController | where {$_.BusSharingMode -like 'Physical'  -or $_.BusSharingMode -like 'Virtual'}).key}).count\n  $REPORT | Add-Member -type NoteProperty -name SharedDisksNum -Value $sharedDisksNum\n\n  $REPORT | Add-Member -type NoteProperty -name noSharedDiskSizeGB -Value ((Get-HardDisk -VM $vmka | where {$_.extensiondata.controllerkey -in ($vmka |Get-ScsiController | where {$_.BusSharingMode -like "NoSharing"}).key}).CapacityGB | Measure-Object -Sum).sum\n  $REPORT | Add-Member -type NoteProperty -name SharedDisksSizeGB -Value ((Get-HardDisk -VM $vmka | where {$_.extensiondata.controllerkey -in ($vmka |Get-ScsiController | where {$_.BusSharingMode -eq 'Physical'  -or $_.BusSharingMode -eq 'Virtual'}).key}).CapacityGB | Measure-Object -Sum).sum\n  $array += $REPORT\n}\n<\/code><\/pre><\/div>\n\n\n\n
Most likely, you would need to modify the scripts to better suit your specific task. Nevertheless, I hope the ones presented above will be helpful.<\/p>\n","protected":false},"excerpt":{"rendered":"
Please use all scripts published by me with caution. The scripts have been tested in my environment and are functional, but I do not take responsibility for how they may behave in your environment. Scirpt to calculate disk number: Script to check various disk parameters: Script to check Physical or … <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1228","post","type-post","status-publish","format-standard","hentry","category-vmware"],"_links":{"self":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/1228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/comments?post=1228"}],"version-history":[{"count":4,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/1228\/revisions"}],"predecessor-version":[{"id":1232,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/posts\/1228\/revisions\/1232"}],"wp:attachment":[{"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/media?parent=1228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/categories?post=1228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.labiol.xyz\/index.php\/wp-json\/wp\/v2\/tags?post=1228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}