Liongard Library

Welcome to Liongard Library, where Lions share! This is a community-led space where Liongard users can come to teach and learn from one another.
Share custom Metrics, get inspired and see what’s trending in the Pride.

Pride Etiquette:
➕ Have great custom Metrics? Add them as entries!
🌟 Want to use a Metric? Copy the query and follow this doc.
👍 Tried a Metric from the Library? Like it!
📣 Have a question or feedback on a Metric? Add a comment!
🔎 Not sure where to start? Learn about Metrics and how to write them.
💬 Need help writing a metric or want to help support others? Join the conversation in our Liongard Lounge #metrics slack channel.


🥴 See something off? Open a support chat to let us know.

Add a new Metric entry Subscribe
Categories Microsoft 365
Created by Austin B [QuoStar]
Created on Nov 23, 2022

RELATED METRIC

Microsoft 365: Licenced Mailbox User

Lists all users with a licenced mailbox (not all data prints can use the "?Has_Exchange_License == `True`" due to type of licence and graph permissions!!)


  • Can be turned into a count with length(@)

  • Can also separate enabled and disabled with "&& accountEnabled == `true`" and "&& accountEnabled != `true`"

  • Also check for active last 30 days with "&& activeLast30Days == `true`"

All &&'s are best placed at the beginning before the product options...

Query

Users[?userType == `Member`

&& (contains (Assigned_Products,`Office 365 E3`)

||contains (Assigned_Products,`Office 365 E5`)

||contains (Assigned_Products,`Microsoft 365 Business Premium`)

||contains (Assigned_Products,`Microsoft 365 Business Standard`)

||contains (Assigned_Products,`Microsoft 365 Business Basic`)

||contains (Assigned_Products,`Microsoft 365 E3`)

||contains (Assigned_Products,`Microsoft 365 E5`)

||contains (Assigned_Products,`Exchange Online (Plan 1)`)

||contains (Assigned_Products,`Exchange Online (Plan 2)`)

||contains (Assigned_Products,`Microsoft 365 A3`))

].displayName | sort(@)
  • Attach files