[en] Architecture of Microsoft 365 functionality

[en] This section describes the architecture of the Microsoft 365 functionality in Snow License Manager as from version 9.12.

[en] Data flow

[en] When an aggregation from Snow Integration Manager is performed, it will send data using the Snow License Manager API. The API, in turn, will store the data in the table o365.Import in the SnowLicenseManager database. This row is then picked up by the Microsoft 365 service to be processed. For more information about the data imported from Microsoft 365, refer to section Retrieved information in Microsoft 365 Connector.

[en] The image below describes the data flow for the Microsoft 365 data in Snow License Manager.


[en] For troubleshooting purposes, it is possible to see the data before it is processed by the Microsoft 365 service, by following these steps:

  1. [en] Stop the Microsoft 365 service.

  2. [en] Extract the data from the desired Payload column by using Save results as and choose All files and then store it as a JSON file.


    [en] Select only the columns you need, to reduce disk space need.

[en] ReadModels

[en] In the o365 schema of the Snow License Manager database, there are multiple ReadModel tables that each correspond to a view in Snow License Manager.

[en] The ReadModels that contain historical data haven't been truncated before processing each import. The ReadModels that do not contain historical data shows the current situation that comes from the latest import.

[en] The following table shows the ReadModels in the o365 schema.

[en] ReadModel Name

[en] Description

[en] Historical data

[en] Costs

[en] Contains the cost information of the subscription plans.

[en] Yes

[en] Current Prices

[en] Contains the current prices of the subscription plans.

[en] No

[en] Monthly Subscription Plans Breakdown

[en] Contains the number of active, warning, assigned, and total license information of each cost period’s subscription plans.

[en] Yes

[en] Monthly Subscription Plans Activity Breakdown

[en] Contains the list of subscription plans which are assigned to a Microsoft Office 365 user and their activity information per cost period.

[en] Yes

[en] Monthly Service Activity Breakdown

[en] Contains the total amount of users, active users, unlinked users per relevant application (Skype, Visio, etc.) and per cost period.

[en] Yes

[en] Monthly User Breakdown

[en] Contains the total amount of users, active users, unlinked users per cost period.

[en] Yes

[en] Overview

[en] Contains the overview (assigned plans, total plans, total users, and last import date) of each cost period.

[en] Yes

[en] Overview Subscription Plan

[en] Contains the current state of the subscription plan activities.

[en] No

[en] User History

[en] Contains the total amount of users per cost period.

[en] Yes

[en] Users per Subscription Plan

[en] Contains the list of subscription plans which are assigned to a Microsoft 365 user and their last activity information.

[en] No

[en] User Activity per Service

[en] Contains user activity information that comes from Snow License Manager per service (Skype, Visio, etc.).

[en] No

[en] User Linking Suggestions

[en] Contains the list of users that haven't been linked to a Snow License Manager user and the list of their potential Snow License Manager user matchings.

Exemple 33.

[en] If you want to troubleshoot the User linking suggestions, you can use the table called ReadModelUserLinkingSuggestion.

[en] No

[en] TenantID

[en] The database table Dbo.tblCID contains Customer ID and a column for TenantID. The TenantID can be used to search in the Microsoft 365 service log.

[en] Log location

[en] The default folder for log files is C:\Program files\Snow Software\Logs\Office365Service.

[en] Service dependencies

[en] Some services are dependent on each other in Snow License Manager. Snow Update Service will start the services in the correct order. For Windows to start the services in correct order after a reboot, the following dependencies are added to the services:


[en] If a service is started without its dependency it will make five attempts to connect to the other service. If it fails, the service stops.

[en] SnowLicenseManagerEventStoreService was removed in Snow License Manager 9.14.

[en] SnowLicenseManagerMicrosoft365BFF service was introduced in Snow License Manager 9.14.

[en] Refer to Services in Snow License Manager for more information.