We just announce a new major release of OfficeExpert, the Analytics Solution for Microsoft 365.
It includes a ton of new capabilities around License Management and a brand new capability, Tenant partitioning, which allows you to segment your own data in the UI of OfficeExpert!

The most notable features and improvements are listed below.

Important Information

Two important informations for existing customers who upgrade to this version:

1) OfficeExpert uses now a new MS Graph API to measure and analyze the Azure Login events.
So if you have licensed Teams and M365 Analytics, please make sure that you add the AuditLog.Read.All API to your existingAzure AD Application of the Appliance.

2) For the new Microsoft login capability you need to have the following Redirect URIs for Mobile and desktop apps in place for your existing Azure AD Application of the Appliance.

https://{FQDN of your OE appliance/blank.html
https://{FQDN of your OE appliance}


General Notes

UpdateAppliance v4.0.0
no update
Simulation Bots v3.0.21 r1352
UpdateWindows Proxy v4.0.0
no update
OfficeExpert Power BI Template - QoS
no update
OfficeExpert Power BI Template - Usage Analytics
no updateTeams App:  OfficeExpert ACE v1.2
no updateTeams App:  ACE Bot v1.1
no updatepanagenda Dataminer v1.4.4


New Feature

Tenant Partitioning

Tenant Partitioning allows you to segment and partition all the data right within OfficeExpert with just few mouse clicks. An admin can create as many partitions as they'd like.
Another real cool capability is that you can assign the partitions to other users.
So, for instance, you can easily create a partition which you then assign to the Department Head of Sales. This person can then login (see below the new MS Login capability) and can see only
the data for their partition(s).

The created partitions can be used in the following pages/sections:

  • Level of Engagement
  • All Pages underneath of License Management

New Feature

Chargeback Accounting

This new Chargeback Accounting page plays an important role whenever you want to provide cost figures and other Microsoft 365 related subscription data to costcenter owners or license managers.
The combination with Tenant Partitioning makes it very powerful because one can segment the data and make it available to these personas. An Important piece is, that the Chargeback Accounting page provides you with monthly aggregated data of the important KPI's. So you can go back in time to see how the Subscriptions costs have evolve over time for your individual partition.
Of course you can use the ACE Bot action to deliver an Adaptive Card on a monthly bases to all the recipients.

New Feature

Authenticate with Azure AD (Microsoft Login)

From now on OfficeExpert users can login with their own Azure AD credentials. Just click on the Microsoft Login button and enter your credentials. In case of SSO, you will be logged in immediately.


Note: Only the following Azure AD Users can login into OfficeExpert:

    • Users who have been assigned the Admin or Viewer Role (User Settings)

    • Users who have been assigned to a Tenant Partition (see above)

All other users listed in the Azure AD will not be able to login.

New Feature

Azure Sign-in Events

OfficeExpert collects now Azure Sign-in Events across the M365 landscape and can use this information in any area. It categorizes Applications into known workload categories such as Teams , PowerApps, a.s.o. instead of having dozens/hundreds of individual apps in the list. So it aggregates and filters all the events from the AuditLog.Read.All Graph API on the appliance level .

It stores and saves all activity per user per day. For instance you can easily see if a user uses PowerApps or not and to what extend (number of logins).

This data can currently be consumed via DataMiner and Metabase:  cqx_data.oe_sign_ins


Cost Savings Potential - Deactivated Users timestamp

A small but very important item got added to the Deactived Users list within the Cost Savings Potential Page.

Due to the fact that Microsoft does not hold any timestamp indication when a user got disabled, we added this capability, so that you can see at a glance when a user got deactivated (and still consumes a license).


Level of Engagement

The Level of Engagement page got adjusted because of the Tenant partitioning element.
All the tab names now start with "Partition By...". So if you pick a Partition, then the different tabs will show data from the selected Partition only.

For an admin or viewer user we have introduced a new tab called "All Partitions" where one can see aggregated figures of all the existing Partitions.


LDAP Config

Because of the new Azure AD authentication we have decided to deprecate the LDAP configuration in the next OE release. If you use LDAP atm please switch over to the Azure AD authentication.

Bug FixesSeveral bugs have been have fixed as well (smile)

Available Update Installation Packages

The update can be triggered via the UI of OfficeExpertSettings / System Information page).

If you want to perform the update manually, you can download them from the following location.

Appliance Inplace Update

Recommended! (OfficeExpert Appliance has online access to docker.panagenda.com)        

(OfficeExpert Appliance does not have access to docker.panagenda.com)