You may want to take a look a this script below. It does some of the things you were looking for and may be much more. it also gives you a nicely formatted email with the disk utilization of each VM in each datastore highlighting any datastore with utilization above a specific value in RED. i have copied the script below and also attached the powershell script file. hope you or someone else in the community finds this useful.
$ServerName = "vCenter ServerAddress"
$result = @()
$MailServer = "MailServerAddress"
$Sender = "sending user email";
$SenderName = "sending user Full Name"; #optional
$Receiver = "receivinging user email"; #could be the same as sender address
$MailSubject = "VMware Infrastructure Disk usage";
$MailBody = "";
$threshold_percent = 70; #percentage datastore utilzation threshold
$ds_filter_pattern = "esx_*" #pattern for matching datastores to retrieve
function SendMail()
{
$MailClient = new-object system.net.mail.smtpclient($MailServer)
$MailMessage = new-object System.Net.Mail.MailMessage
$MailMessage.From = new-object System.Net.Mail.MailAddress($Sender, $SenderName)
$MailMessage.To.Add($Receiver)
$MailMessage.Subject = $MailSubject
$MailMessage.IsBodyHtml = $True
$MailMessage.Body = $MailBody
$mailClient.Send($MailMessage)
}
Connect-VIServer $ServerName #Connect to the VMware Infrastructure server (either ESX or vcenter server).
#you may also want to specify a username and password if the account running the script does not have access to the vcenter.
#the line then become "Connect-VIServer -Server $ServerName -Protocol https -User Username -Password password"
if($defaultVIServer -ne $NULL)
{
$msgHTML += "<html xmlns='http://www.w3.org/TR/REC-html40' /><head><meta http-equiv='content-type' content='text/html;charset=UTF-8' />"
$msgHTML += "<meta name=Generator content='Datastores in Virtual Infrastructure' /><meta name=Author content='Kenny Adetutu' />"
$msgHTML += "<style>"
$msgHTML += "BODY{background-color:white;}"
$msgHTML += "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
$msgHTML += "TH{border-width: 1px;padding: 5px;border-style: solid;border-color: black;background-color:thistle}"
$msgHTML += "TD{border-width: 1px;padding: 5px;border-style: solid;border-color: black;background-color:palegoldenrod}"
$msgHTML += "</style></head>"
$msgHTML += "<body style='font-family: arial; font-size: 12;' />"
$msgHTML += "<table >"
$msgHTML += "<tr><th>Datastore Name</th><th>Total Capacity(GB)</th><th>Available Capacity(GB)</th><th>Percent FreeSpace</th><th>VM Disk Usage</th></tr>"
$datastores = get-view -viewtype "datastore" | where {$_.name -like $ds_filter_pattern} | sort name #get-datastore | where {$_.name -like "esx_*"}
foreach ($datastore in $datastores)
{
$ds_capacity = [Math]::Round((($datastore.Summary.Capacity)/1048576000), 2)
$ds_freespace = [Math]::Round((($datastore.Summary.Freespace)/1048576000), 2)
$threshold_value = [Math]::Round((($threshold_percent / 100) * $ds_capacity), 2)
$percent_freespace = [Math]::Round((($ds_freespace / $ds_capacity) * 100), 2)
$msgHTML += "<tr><td>" + $datastore.Name + "</td>"
$msgHTML += "<td>" + $ds_capacity + "</td>"
$msgHTML += "<td>" + $ds_freespace + "</td>"
if(([Math]::Round(100-$percent_freespace)) -gt $threshold_percent)
{
$msgHTML += "<td style='background-color:red;color:white'>" + $percent_freespace + "<br /><span style='font-size:16px'><b>[Over-utilized]</b></span></td>"
}
else{
$msgHTML += "<td>" + $percent_freespace + "</td>"
}
$msgHTML += "<td>"
try
{
$vms = get-view $datastore.vm | where {$_.runtime.powerstate -eq "PoweredOn"}
foreach($vm in $vms)
{
$Total_usage = 0
$sinfo = $vm.storage.perDatastoreUsage
for($i=0; $i -le $sinfo.length-1; $i++)
{
if($sinfo[$i].Datastore.Value -eq $datastore.MoRef.value)
{
$Total_usage = [Math]::Round(($sinfo[$i].Committed/1048576000), 2)
}
}
$msgHTML += "<table style='border-style:none;'><tr><td style='background-color:thistle'>VM Name</td><td>" + $vm.name + "</td></tr>"
if($Total_usage -gt $threshold_value)
{
$msgHTML += "<tr><td style='background-color:thistle'>Total Disk Usage(GB)</td><td style='background-color:red'>" + $Total_usage + "</td></tr>"
}
else{
$msgHTML += "<tr><td style='background-color:thistle'>Total Disk Usage(GB)</td><td>" + $Total_usage + "</td></tr>"
}
$msgHTML += "</table><br />"
}
}
catch
{
write-warning "Error: the datastore $($datastore.Name) doest not have any VM"
}
}
$msgHTML += "</table>"
$body = $msgHTML
$MailBody = "<b>The Virtual Infrastructure disk usage is displayed in the below.</b><br /><br />" +$body+ "<br /><b>Thanks.<b>"
SendMail
}
Disconnect-VIServer $ServerName -Confirm:$false
