Skip to main content

Import license assignments from Microsoft 365

Alvao can automatically import Microsoft 365 (M365) license assignments.

Installation​

  1. Download the ImportM365Licenses.zip file and extract it.

  2. Go to Administration - Applications and import the extracted ImportM365Licenses.xml file.

  3. 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

  4. Go to Administration - Settings – Advanced and configure following parameters using the values from 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

  5. Go to Administration - Applications and enable the application.

Initial import​

The application retrieves license information from M365 and attempts to map it by the identifier for licensing to existing software licenses in Alvao, which must contain the identifier in the License ID in external system field. If there is no license in Alvao that matches the M365 license, an error message is written to the Diagnostics log.

Check the Diagnostics log for the error message: "License 'identifier' not found in database". If the log contains such messages for each message, create a new software license using the Software - Licenses - New license command or enter the identifier contained in the message into the License ID in external system field of the existing license. The license must have the per user quantity unit. You don't need to enter the exact license quantity and license assignments, as they will be imported automatically.

After the initial import, licenses in Alvao are update regularly every day during specified hours.

In exceptional cases, the license quantity field may contain an inaccurate value in Alvao. If the license in M365 is exceeded (i.e., it is assigned to more users than its size allows), the Quantity field contains the total number of users to whom the license is assigned, and the Notes field contains information about the exceeded license.