Microsoft Office 365 License Statistics

This template shows information about Office 365 Subscription Statistics and includes the following Component Monitors:

  • License Usage Over Time - Consumed license units based on part number (SKU)
  • Subscription Overview - Number of active subscriptions in your environment
  • License by User - users with more than the threshold limit of licenses associated with their account
  • Users without License -users who have a license count of 0
  • Subscriptions Assigned by User - number of subscriptions for each user
  • Users with No Subscriptions - users with no subscriptions associated with them

Prerequisites

WMI access to the target server

Check the following article for prerequisites: http://technet.microsoft.com/en-us/library/jj984289(v=exchg.150).aspx Connect to Exchange Online Using Remote PowerShell.

Important: The PowerShell script mentioned in the Microsoft article above should be run on the Orion server, not the target node.

Credentials

  • An Orion account with SAM administrator permissions.
  • An Office 365 account with global administrator privileges.
    • The account must be a member of an Office 365 admin role.
    • The account should be an all-in-one, inclusive account to support the monitoring of all mailboxes.

Use UPN format (username@domain) — 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.