Skip to main content

Microsoft 365 license import

This feature provides tools for tracking, analyzing, and reporting the allocation and active usage of Microsoft 365 subscription plans across the organization. It aggregates telemetry and license assignment data to help administrators align subscription costs with actual user needs and maintain license compliance.

Configuration (from version 26.3)​

  1. (This step applies only to on-premises installations.) In the Microsoft Azure portal, add the following Microsoft Graph application permissions (not delegated permissions) to the existing Alvao app in your Microsoft Entra ID tenant:

    • User.Read.All
    • Organization.Read.All

  2. Go to Administration - Settings - Microsoft Entra ID.

  3. Click on the Microsoft 365 licenses - Provide consent and grant the required permissions to read Microsoft 365 license information.

  4. Select the Enable checkbox and click OK.

Configuration (version 26.2 and below)​

  1. Go to Administration - Applications and enable the Import M365 Licenses application.

    Manual download: ImportM365Licenses.xml

  2. Go to the Azure Portal and open Microsoft Entra ID for your tenant.

    • Create new app registration.
    • Create new client secret and store it on safe place for later use.
    • Add following application permissions for Microsoft Graph:
      • Organization.Read.All
      • User.Read.All

  3. In Alvao - Administration - Applications - Import M365 Licenses, configure following settings using the values from MS Entra ID app registration.

    NameDefault valueDescription
    ImportM365Licenses.AtHours2Comma-separated list of day hours when to execute import.
    ImportM365Licenses.ClientIdApplication Client Id from the app registration in MS Entra ID
    ImportM365Licenses.ClientSecretApplication Client secret
    ImportM365Licenses.TenantIdTenant Id

  4. Enable the application.

Importing licenses​

Alvao retrieves license information from Microsoft 365 and automatically creates license records on the Software - Licenses page. The following license fields are populated:

  • License name
  • License type - Normal
  • Quantity unit - per user
  • Quantity
  • Valid from - because Microsoft Graph API does not provide the license purchase date, this field contains date when the license was first imported.

After the initial import, licenses in Alvao are updated daily. Licenses are identified by the value of the License ID in external system field.

The following license fields are updated in Alvao:

  • Valid to - because Microsoft Graph API does not provide the license expiration date, this field contains the date when the license was first detected as expired.
  • Quantity
  • Assignment - licenses are automatically assigned to existing user objects. User objects are not created automatically. You can view license assignment on the Software - Licenses - License - Assignment tab.

By default, the licenses are imported once a day at 2:00 AM (in the Alvao server time zone). To change or extend the import schedule, go to Administration - Settings - Advanced and add the ImportM365Licenses.AtHours setting. Specify a comma-separated list of day hours during which the import should run.

Version 26.2 and earlier: In exceptional cases, the Quantity field may contain an inaccurate value. If a Microsoft 365 license is overallocated (that is, assigned to more users than the license capacity allows), the Quantity field contains the total number of assigned users, and the Notes field contains information about overallocation.