Office 365 license consumption alert

HiCarlos Gomez and everyone else! I recently wrote a blog post on this one and included my sample PowerShell code - comments welcome on the blog!! Thanks.

https://itinvt.com/index.php/2021/11/21/email-alerts-for-low-office-365-licenses/

Carlos Gomez 

Its not pretty but this will do what you want.  I have configured it for SPE_E3 sku but you can change it for which ever license type you want in the variables.  it will send an email when there are 10 licenses left.  Keep in mind if you use 10 licenses in between the script run cycles you might get notified too late. 

$sku =Get-MsolAccountSku | where accountskuid -EQ "tennant:SPE_E3"
$skuactive=$sku | select activeunits
$skuconsumed=$sku | select consumedunits
$skuadd10 = $skuconsumed.ConsumedUnits +10
if ($skuadd10 -ge $skuactive.ActiveUnits) {Send-MailMessage -SmtpServer smtpserver01 -To geeman@maildomain.com -From geeman@maildomain.com -Body test -Subject test }

Carlos Gomez, this is probably coming late. Just thought I should share this should anyone else needs it. https://insterswap.wordpress.com/2020/03/29/automatically-alert-your-team-when-your-tenant-is-running-low-or-out-of-office-365-license/

Depending on how big or complicated your environment is, the alert script may require a little modification. Our need was just as simple as “tell us when our license is low or out”. As the saying goes, necessity is the mother of invention. Feel free to modify the script.

This issue, the lack of an Office 365 license consumption alert, is still unresolved (06/22/2018). 

There is a feedback forum post for the task; https://feedback.azure.com/forums/169401-azure-active-directory/suggestions/33768322-get-low-license-count-notification 

Please vote it up if you really want to see the change. 

And as others have noted, you can set up a scheduled task to PowerShell an email to your relevant crew who may see going to the portal as an inconvenience. 

I included my script below with <descriptions> of items that need filled in. 

If you need help getting keys and such to encrypt passwords, try Share-gate or KeePass who provide good MS Online compatible encryption tools. 

# 
# Send_O365LicensingReport.ps1 
#

$key = (<integer array>); 
$secureString = "<encrypted Password>" 
$PWord = ConvertTo-SecureString $secureString -key $key; 
$User = "<GlobalAdmin>@<company domain or .microsoftonline.com>"; 
$Credential = New-Object –TypeName "System.Management.Automation.PSCredential" –ArgumentList $User, $PWord

#Get the Office365 tenant credentials 
$Office365credentials = Get-Credential $Credential;

Connect-MsolService -Credential $Office365credentials; 
write-host "Connecting to Microsoft SharePoint Online Service ..."

[String]$SkuReport1 = Get-msolAccountSku | Select @{N='Product Name';E={switch ($_.AccountSkuId) { '<company domain>:ENTERPRISEPREMIUM' {'Office 365 Enterprise E5'} '<company domain>:POWER_BI_PRO' {'Power BI Pro'} '<company domain>:ENTERPRISEPACK' {'Office 365 Enterprise E3'} '<company domain>:SHAREPOINTSTORAGE' {'SharePoint Online Storage'} '<company domain>:POWER_BI_STANDARD' {'Power BI (free)'} '<company domain>:EMS' {'Enterprise Mobility + Security E3'} '<company domain>:MCOMEETADV' {'Audio Conferencing'} '<company domain>:DYN365_ENTERPRISE_SALES' {'Dynamics 365 for Sales Enterprise Edition'} '<company domain>:DYN365_ENTERPRISE_TEAM_MEMBERS' {'Dynamics 365 for Team Members Enterprise Edition'} default {'Unknown'} }}}, @{N='Active Units';E={$_.ActiveUnits}}, @{N='Consumed Units';E={$_.ConsumedUnits}}, @{Name = 'RemainingUnits'; Expression = {[string]([int]( $_.ActiveUnits - $_.ConsumedUnits))}}, @{N='Account SkuId'; E={$_.AccountSkuId}} | ConvertTo-Html

Send-MailMessage -SmtpServer mail.<company domain> -To <recipient>@<company domain> -From <sender>@<company domain> -Subject "Consumed licenses report" -Body $SkuReport1 -BodyAsHtml