Microsoft 365: Shared Mailboxes with Assigned Licenses | Voters

Microsoft 365: Shared Mailboxes with Assigned Licenses

submitted

Kevin Fuller

Use for trying to find Shared Mailboxes that still have a license assigned.

Users[?Recipient_Type ==

Shared

&& assignedLicenses.length(@) >

].[userPrincipalName, Assigned_Products][]

David Bourgeois

Good one. Try this change in code to better display the results (expecially in Power BI!). Users[?Recipient_Type ==

Shared

&& length(assignedLicenses) >

].{ User: userPrincipalName, Products: Assigned_Products }[]