Version 1

    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: