Hi LucD - so if I wanted to take this script and have the output just provide me with the name - how can I do that? When I strip down the report I am getting an Attempted to divide by zero error....I want the report to only provide output for Used% > 90 AND if provisionedspaceGB > totalspaceGB. I want to still have the option to add datastores I don't want checked as well.
#powershell script to query the datastores for Used% > 90% AND provisionedpsace > totalspace
connect-viserver '<server>' -User '<user>' -Password '<password>'
$undesiredDatastores = @('local*')
$TotalSpaceGB=[math]::Round($_.CapacityGB,0)
$UsedSpaceGB=[math]::Round($_.CapacityGB - $_.FreeSpaceGB,0)
$UsedSpace%=[math]::Round(($_.CapacityGB - $_.FreeSpaceGB)/$_.CapacityGB*100,0)
$ProvisionedSpaceGB=[Math]::Round(($_.CapacityGB - $_.FreeSpaceGB + $_.ExtensionData.Summary.Uncommitted/1GB),0)
$AmountOverprovisionedGB=[Math]::Round($_.ExtensionData.Summary.Uncommitted/1GB – $_.FreeSpaceGB,0)
$report=Get-Datastore |
where{$undesiredDatastores -notcontains $_.Name} | Select Name | Where{$_.'UsedSpace%' -ge 90 and $_.'ProvisionedSpaceGB' -gt $_.'TotalSpaceGB'} |
Sort-Object -Property Name
