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 | |
---|---|
Update | Appliance v4.0.0 |
no update | Simulation Bots v3.0.21 r1352 |
Update | Windows Proxy v4.0.0 |
no update | OfficeExpert Power BI Template - QoS |
no update | OfficeExpert Power BI Template - Usage Analytics |
no update | Teams App: OfficeExpert ACE v1.2 |
no update | Teams App: ACE Bot v1.1 |
no update | panagenda Dataminer v1.4.4 |
Appliance | |
---|---|
New Feature | Tenant PartitioningTenant 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:
|
New Feature | Chargeback AccountingThis 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:
All other users listed in the Azure AD will not be able to login. |
New Feature | Azure Sign-in EventsOfficeExpert 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 |
Improvement | Cost Savings Potential - Deactivated Users timestampA 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). |
Improvement | Level of EngagementThe Level of Engagement page got adjusted because of the Tenant partitioning element. 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. |
Improvement | LDAP ConfigBecause 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 Fixes | Several bugs have been have fixed as well |
Available Update Installation Packages
The update can be triggered via the UI of OfficeExpert ( Settings / 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)