cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Microsoft Office 365 License Statistics v2 (November 2018)

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:

Labels (1)
Attachments
Version history
Revision #:
1 of 1
Last update:
‎11-20-2018 09:43 AM
Updated by: