Microsoft Office 365 License Statistics
This template shows information about Office 365 Subscription Statistics.
The following Component Monitors are included:
- License Usage Over Time
- Subscription Overview
- License by User
- Users without License
- Subscriptions Assigned by User
- Users with No Subscriptions
Prerequisites:
- Install-Module -Name AzureAD
- Connect-AzureAD
- Install-Module -Name MSOnline
- Check the following article for prerequisites:
https://docs.microsoft.com/en-us/microsoftteams/office-365-groups
Credentials:
- The user should have SAM Administrator permissions
- Office 365 account with global administrator privileges.
MONITORED COMPONENTS
- License Usage Over Time
- Consumed license units based on part number (SKU)
- Unit: Number
- Subscription Overview
- Number of active subscriptions in your environment
- Unit: Number
- License by User
- Users with more than the threshold limit of licenses associated with their account
- Unit: Number
- Users without License
- Users who have a license count of 0
- Unit: Number
- Subscriptions Assigned by User
- Number of subscriptions for each user
- Unit: Number
- Users with No Subscriptions
- Users with no subscriptions associated with them
- Unit: Number
Troubleshooting steps
Detail troubleshooting steps (common for template)
- Use UPN format (username@domain) and not domain\username format to enter credentials. Also, a service account for Exchange Web Services is recommended to avoid authentication issues when passwords are updated.
Detail troubleshooting steps (specific for components)
- Make sure the machine where the Monitors execute i.e Powershell Scripts, the Azure-AD and MSOnline is installed and connected.
Portions of this document were originally created by and are excerpted from the following sources: