Comments on: Why Microsoft 365 License Assignment Dates Can Be Misleading

By: Tony Redmond

Tony Redmond — Sun, 12 Nov 2023 14:46:41 +0000

In reply to Derek.

Yep. I cover reporting of group-based licensing in https://practical365.com/group-based-licensing-report/

By: Derek

Derek — Sun, 12 Nov 2023 13:51:33 +0000

In reply to Tony Redmond. Besides the audit log for User License Updated (individual changes), we would also need to check AD group membership changes and AD group assigned licenses, correct?

By: Tony Redmond

Tony Redmond — Mon, 17 Apr 2023 11:27:04 +0000

In reply to Ameer. Billing date for subscriptions is coming (or so I hear from Microsoft)

By: Ameer

Ameer — Mon, 17 Apr 2023 09:46:32 +0000

Where do we get the billingenddate for the subcriptions of our tenants in O365 Products without using the MsolSubscription in powershell

By: Tony Redmond

Tony Redmond — Tue, 14 Mar 2023 17:42:29 +0000

In reply to Carl Knecht. Yep. This is a real pain...

By: Carl Knecht

Carl Knecht — Tue, 14 Mar 2023 16:02:12 +0000

I really wanted something like this to be native from Microsoft but found the same — automated changes by Microsoft reset the date making it an unreliable data source. I wrote a script that gathers user licensing information similar to your methods above, compares to log file from the previous run, and keeps a running date for when that subscription was initially assigned. I store everything on a SPO site and have that data going back to 2019 when I first started. It’s been VERY helpful when making additional decisions about reclamation, especially comparing to things like the Project usage report. Newly assigned license that hasn’t been used in 90 days after assignment? Older license that hasn’t been used in 180 days? Those get made available for others to use. Without knowing when the assignment occurred, those decisions can’t be made. Having the initial assignment data within a week’s worth of time has been good enough for us.

Original script was using AzureAD module, but I migrated to Microsoft Graph PowerShell SDK last year. There is probably some solution out there that would have taken care of all this for us, but this was also a great way to learn how to interact with the Microsoft Graph PowerShell SDK and serves us well, even if there is occasional maintenance needed.