question Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement in SAM forum

Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

Tim18 — Thu, 24 Sep 2020 08:38:29 GMT

Hi,

I was wondering whether anyone has come across/have the solution to how I can reconcile Office 365 E3 usage (coming from the Office 365 integration) with entitlement for Microsoft 365 E3?

Office 365 E3 is essentially a component of M365 E3, although I don't believe that is contractually recognised in the respective licensing. https://www.microsoft.com/en-gb/microsoft-365/enterprise/compare-microsoft-365-and-office-365. I was hoping that I could get around it by setting Office 365 E3 as a suite component, but that does't get applied in the reconciliation results - presumably because subscriptions don't have the concept of suites.

Plan B is to ask our ServiceNow admins to setup a script to transform the Office 365 E3 subscription data when it comes in to M365 E3 so we can reconcile it. However that feels like it should be a last resort so wanted to check here first.

Many thanks

Re: Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

rohantyagi — Fri, 25 Sep 2020 14:16:07 GMT

Hi Tim,

We are developing the solution to reconcile Microsoft 365 components like Office 365, windows10 and EMS into one Microsoft 365 software. [Under Servicenow standard safe harbor] This will be available in the Quebec release. However we are also considering backporting it to older releases, i will be able to give you more information on the timelines or patch number in the next 3-4 weeks. Please tag me in the comment if you don't hear back.

I am also happy to show you how this is going to work in one of our development environments. If interested, please send me an email at rohan.tyagi@servicenow.com

Regards,

_Rohan

Re: Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

Tim18 — Fri, 25 Sep 2020 14:41:48 GMT

Hi Rohan, thanks for the update - I will drop you an e-mail as would be interested to have a look.

Thanks again

Re: Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

Jeff Barratt — Fri, 18 Dec 2020 03:17:41 GMT

@rohantyagi we just encountered this issue while implementing. Any update you can share on the patch status / release of this feature? Would also love to see this in action if that's possible.

Thanks!

Re: Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

cbester — Fri, 11 Jun 2021 21:21:49 GMT

@rohantyagi - We are trying to reconcile the M365 licenses as well. We are currently using Paris - is this available for us? and, if not, is it available in Quebec? Thanks!

Re: Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

mikewhalley1 — Mon, 14 Jun 2021 07:07:42 GMT

We've been struggling with this. It hasn't been back-ported to Paris. One of my other customers is using Quebec and the solution Rohan outlines precludes the need to mess around with the suite components and inference percentages for O365, EMS and W10.

That said, I think there is a much-needed whitepaper that discusses the best practice for managing suites. I've said it before and I'll say it again: getting the correct results when reconciling suites appears to be trial and error based on the suite components, mandatory products and inference percentages. It shouldn't be like this.

Re: Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

Churchie — Thu, 08 Sep 2022 13:46:43 GMT

Rohan, any update on this?
We are struggling with reporting usage for the web based Office suite for our M365 subscriptions. The O365 integration seems to ignore these and only reports for products like Yammer, Teams, Visio etc but no Office Suite of products. Also, the integration does not populate anything in the samp_sw_o365_usage_report table. Is that normal with M365 Subscriptions?

Our customer wants to be able to see which online apps are being accessed (last_activity) in the subscription table (samp_sw_subscription).

If this is not possible, are we able to allocate local desktop Office suite installations against our M365 entitlements? Does reconciliation account for that along with showing usage somehow? I'm guessing that comes from SCCM?

Thanks,

Darren

Re: Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

Anwer — Tue, 13 Jun 2023 14:24:56 GMT

Is there an update for this issue? We are on Tokyo and even when integrating to the Microsoft Portal we are seeing all components separately broken out instead of a suite of products for M365 (office apps, win 10, ems)

Re: Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

Hong Ngoc Trinh — Tue, 12 Dec 2023 16:57:47 GMT

Is there any update for this issue? We are on Utah and also struggling with this, instead of a suite of product for Microsoft 365, the components are broken out. Please advise the solution.

Re: Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

Nitin Agarwal2 — Thu, 23 May 2024 14:07:12 GMT

@rohantyagi Is this solution developed? Windows 10 and similar components are not part of M365 suite component. We need to manually configure suite for each model under M365. This can mess up the OOB functionality in ServiceNow.

Re: Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

SrinivasRamanu1 — Thu, 30 May 2024 07:02:40 GMT

hi all, we are already supporting this. Please check the latest blog on this: https://www.servicenow.com/community/sam-blog/microsoft-365-licensing-use-cases-some-advanced-scenarios/ba-p/2947559

Re: Reconciling Office 365 E3 subscription data with Microsoft 365 E3 entitlement

Anwer — Thu, 30 May 2024 13:42:47 GMT

Just an FYI, Microsoft has some additional M365 packages for government users (GCC) that may have different PPN than the commercial M365. These government versions still need to have the appropriate suite components defined. We have opened a ticket to have this pre-defined by the content library.