Comments on: How to Create a Microsoft 365 Licensing Report Using the Microsoft Graph SDK for PowerShell

By: Darren

Darren — Tue, 17 Oct 2023 05:40:53 +0000

In reply to Tony Redmond. Thats what I am trying to do

By: Tony Redmond

Tony Redmond — Mon, 16 Oct 2023 23:00:10 +0000

In reply to Darren Zappa. You mean like have separate columns for Office 365 E3, Office 365 E5, EM+S, etc? If so, you'd extract the licenses from $user.assignedlicenses and use that information to populate separate properties in the output report.

By: Darren Zappa

Darren Zappa — Mon, 16 Oct 2023 22:57:30 +0000

In reply to Tony Redmond. I want to seperate the licences into their own columns if possible - I cannot see a way to do this?

By: Tony Redmond

Tony Redmond — Sat, 14 Oct 2023 05:28:26 +0000

In reply to Darren. Do you mean that you want a report for just one selected license?

By: Darren

Darren — Sat, 14 Oct 2023 03:37:34 +0000

Hi Tony,
Great script – works like a charm!
I have been trying to seperate the assigned licenses from the “Direct assigned licenses” heading so that I can filter by license – e.g. a user may have “Microsoft Power Automate Free, Microsoft 365 Business Premium
“, another usere may have “Project Plan 3, Microsoft 365 Business Premium”, etc. – I want to filter by “Microsoft 365 Business Premium” for example.
Is this possible?
Darren

By: Tony Redmond

Tony Redmond — Wed, 16 Aug 2023 11:43:33 +0000

In reply to Ben.

No worries. There’s a good book 😉 covering the SDK and all its ups and downs (see chapter 23 of https://gum.co/O365IT/).

By: Ben

Ben — Wed, 16 Aug 2023 11:39:06 +0000

@AusSupport
Scheduling the script is relatively easy but you need to do some preparation for it to work:
– App registration in Azure
– (Self-signed) certificate to replace the interactive authentication
– Service account for running the script (regular user account with “Logon as a batch job” or better GMSA in Active Directory environments)

Too much to describe in detail within a comment section. 😉

By: Ben

Ben — Wed, 16 Aug 2023 11:35:58 +0000

Hey Tony,
I just wanted to leave you with a big THANK YOU for your good work! It saved me hours of trial and error (and cursing :-D) and works like a charm!
I added multi-customer support and app-only authentication so we can automatically generate reports for all our customers but this was only a small thing compared to your groundwork.

…and still works with Graph V2 (Microsoft released it at the end of July without big announcement or anything). 🙂

By: Tony Redmond

Tony Redmond — Wed, 16 Aug 2023 09:37:55 +0000

In reply to AusSupport.

Use Azure Automation. There are a bunch of articles about this topic on this site, like https://practical365.com/microsoft-graph-sdk-powershell-azure-automation/

By: AusSupport

AusSupport — Tue, 15 Aug 2023 02:37:44 +0000

Hi Tony,

Thanks for the Script and we can save lots of E5 licenses. Can you direct me to schedule this report?