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 115 of 904

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 almost 2 years ago in Microsoft 365 0

Microsoft 365: Maximum Secure Score

Returns the maximum secure score possible for the tenant.
Paul Taplett almost 2 years ago in Microsoft 365 0

Microsoft 365: Privileged User w/ License

Best Practices are for admin accounts to not contain a license unless required. This metric outputs Privileged users and what products they are assigned
Devon about 3 years ago in Microsoft 365 0

[Microsoft 365: Non-Admin, Non-Guest, License Assigned, MFA disabled]

This query looks for non-admin users who have an active license within your organization that do not have MFA enabled (ignoring guest users).
Charles Van Duynhoven almost 3 years ago in Microsoft 365 5

Office 365: Visio Online (Plan 2) Active License Count

Visio Online (Plan 2) Active License Count
Matthew Waddell about 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] about 2 years ago in Microsoft 365 0

Microsoft 365: Mailbox Size Greater than XX

This will look for users with mailboxes larger than 45. Customize the value to change Metric. Output will include mailname and size of mailbox.
Devon over 2 years ago in Microsoft 365 2

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] almost 2 years ago in Microsoft 365 0

Microsoft 365: Count of All Group Members

This metric displays a count of all active group members.
Michael Thompson 6 months ago in Microsoft 365 0

Microsoft 365: Percent of Storage Used over 90

Checks for Storage_Used existing, then any users with over 90% storage used, then prints the name and amount of storage used
Leland Shane over 2 years ago in Microsoft 365 0