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

Microsoft 365

Showing 114 of 880

Microsoft 365: Nonprofit License Excluding Donated Licenses

Use this query when syncing nonprofit licenses. You can change the consumedUnits that are subtracted depending on the donated licenses.
Phil at Gradient MSP over 1 year ago in Microsoft 365 0

Microsoft 365: Count of Active Users with Consumed Licenses

Count of active users with consumed licenses over multiple licenses.
Phil at Gradient MSP over 1 year ago in Microsoft 365 0

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 "&...
Austin B [QuoStar] over 1 year ago in Microsoft 365 0

Microsoft 365: Count of Active Users with Exchange

Returns the count of active users that have an Exchange license enabled.
Phil at Gradient MSP over 1 year ago in Microsoft 365 0

Microsoft 365: Exchange Licensed user w/ 95% full mailbox

Outputs percentage of Storage used against full mailbox size in addition to the email address and mailbox size. Microsoft's built in warning to the user is at 98%, Prohibits sending at 99%, and Prohibits receiving at 100%. This can be customized b...
Devon over 1 year ago in Microsoft 365 2

Microsoft 365: Maximum Secure Score

Returns the maximum secure score possible for the tenant.
Paul Taplett over 1 year ago in Microsoft 365 0

Microsoft 365: Total Licenses Consumed

Total licenses consumed.
Phil at Gradient MSP over 1 year ago in Microsoft 365 0

Microsoft 365: Security Score as Percentage

This metric returns a tenant's Microsoft 365 security score as a percentage of points available. It is an integer, but if you want it to a couple of decimal places, simply remove the ceil function.
Guest over 1 year ago in Microsoft 365 2

Microsoft 365: Consumed License Count by Product Name

Returns the count of consumed licenses by product. A useful metric when reconciling services in the Gradient MSP billing module.
Phil at Gradient MSP over 1 year ago in Microsoft 365 0

Microsoft 365: Unused License Count by Product Name

Returns the count of unused licenses by product. A useful metric when reconciling services in the Gradient MSP billing module.
Phil at Gradient MSP over 1 year ago in Microsoft 365 0