Forum Discussion
Office 365 license consumption alert
In terms of alerts, no. A quick glance at the Admin portal or the Reports can give you this info. If you need it automated it really takes few lines of PowerShell code to check for available licenses and fire up an email notification.
In terms of alerts, no. A quick glance at the Admin portal or the Reports can give you this info. If you need it automated it really takes few lines of PowerShell code to check for available licenses and fire up an email notification.
- Hallo zusammen, Danke für die Super Unterstützung
Hi everyone,
even if this threat appears to be stuck or dead - I would be very interested to get the powershell code for getting alerts on low license counts - based on comparision of purchased and assigned licenses directly on the tenant level.
Would be very appreciated.
best regards
Markus
It takes two lines of PowerShell, and you have all the building blocks in the replies above.
Hi Vasil,
thank you for the reply. The parts I can find above are how to send mails via powershell - got that, no issue.
I want to go straight to the available license information within the Admin Center -NOT- exporting all licensed users, counting them, storing in a file / variable looping through E1 and E3 users, and then compare it against the SUM of available licenses in the tenant.
I just want to get the latest part done - get the amount of purchased licenses from the tenant. Do you have an hint, how to get this information direct?
best regards
Markus
Hi Vasil,
Do you know if there is a way to schedule the reports to be send? instead of going every day to open the admin portal and look for the report.
Regards.
If you go the PowerShell route and want a schedule report you can always set it up on a server to run as a schedule task on a recurring basis. I've done a few reporting solutions this way to achieve a scheduled report :)
- Must probably we will use this way, but would be nice if microsoft provides this out of the Box.
Unfortunately no, only few reports have the schedule functionality (the EOP related ones).
I was wondering if someone has got that Powershell code for viewing license and setting up for email notification.
I know how to view license (Get-MsolUser -UserPrincipalName belindan@litwareinc.com).Licenses.ServiceStatus - how do i add this to a notification email.
Thanks
Sending messages via PowerShell is very easy. Get the information you want via the licensing cmdlets, then simply use something like:
$body = "blabla you have $somevariable available licenses out of $anothervariable blabla"
Send-MailMessage -SmtpServer outlook.office365.com -To user@domain.com -From you@domain.com -Subject "Free licenses report" -Body $body -BodyAsHtml -UseSSL -Credential (Get-Credential)
Of course if you aim to automate it you can use a different account, store the credentials securely and reuse them. You can also use your own SMTP server instead of O365 ones, etc.
Thanks Vasil much appreciated
