I would like to run the following but only retrieve sku: MCOMEETADV. It gives me everything.
$customformat = @{expr={$.AccountSkuID};label="MCOMEETADV"}, @{expr={$.ActiveUnits};label="Total"}, @{expr={$.ConsumedUnits};label="Assigned"}, @{expr={$.activeunits-$.consumedunits};label="Unassigned"}, @{expr={$.WarningUnits};label="Warning"} $result = Get-MsolAccountSku | sort activeunits -desc | select $customformat $runningout=@() $result | foreach{ if($.unassigned -le 5){ $runningout+=$ } } [string]$body=$runningout | convertto-html [string]$body=$result | convertto-html $cred=Get-Credential send-mailmessage -from test@test.com -To test@test.com -SmtpServer smtp.test.com -Port 587 -Body $body -Subject "Daily Office 365 License Report" -BodyAsHtml -Credential $cred
