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 879

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: Maximum Secure Score

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

Office 365: Global Admin Summary

Lists all explicit global admins Useful for distinguishing privileged roles from global admin Change sort(@) to length(@) to get a count Change == to != to identify privileged, but no global admin
Austin B [QuoStar] over 1 year ago in Microsoft 365 0

Microsoft 365: Return Additional Data via M365 Inspector (Checks the 365 concealed user, group, and site names in all reports Setting)

In order to return more data via the Microsoft 365 inspector, you need to disable the setting "Display concealed user, group, and site names in all reports" in the 365 tenancy (refer to Liongard documentation for more information). This metric wil...
Sam Walker about 2 years ago in Microsoft 365 2

Microsoft 365: Safe Links Enabled

Uses Microsoft 365 secure score to check if you meet the requirements for Safe Links. Provides True/False Response.
Jai Dametto over 2 years ago in Microsoft 365 0

M365: Non-Admin Users with MFA Enabled List

This is helpful to someone who's trying to obtain/maintain visibility into the non-admin users in an organization's M365 instance. This is a good Metric for QBRs, recurring site reviews, and an onboarding report. Also, this Metric could be used to...
De'Shard Brown over 2 years ago in Microsoft 365 4

Office 365: Disabled Users with active E3 Licensing

Will show any users who are disabled that still have an active E3 license that likely does not need to be assigned.
Nick Dechnik over 2 years ago in Microsoft 365 1

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 Licenses by Product Name

Returns the number of licenses for a single skuPartNumber. Product names and service plan identifiers for Microsoft 365 licensing can be found here. Simply insert the skuPartNumber into the query. This is a useful metric when reconciling services ...
Phil at Gradient MSP almost 2 years ago in Microsoft 365 0

Microsoft 365: Users w/ MFA Enabled Count

Counts the number of users with MFA enabled in the entire Environment. Useful for determining the rollout of MFA or reporting. Does not require the P1 license.
Zyad Khan almost 2 years ago in Microsoft 365 1