Skip to Main Content
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 take a course on how to write them from Liongard Academy!
💬 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 127 of 972

Microsoft 365: Users w/ Associated Licenses

This Metric is great for Reports (QBRs and Licensing Audits) and gaining and sharing granular visibility into user's licensing status.
Addison Caldwell almost 4 years ago in Microsoft 365 0

Microsoft 365: List of Drives Over 80% Capacity (Includes Sharepoint and OneDrive)

Category: Storage Monitoring Metrics Description: This metric provides a detailed overview of Microsoft 365 drives - including Sharepoint and Onedrive drives that have exceeded 80% of their storage capacity. It highlights drives with limited avail...
Lamont Largie 5 months ago in Microsoft 365 1

Microsoft 365: Sharepoint Sites with Drive name and total size

The resulting example in the screenshot
De'Shard Brown 5 months 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 over 3 years 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 2 years ago in Microsoft 365 2

Office 365: Stale Mailboxes

Lists active stale users that are licensed with a mailbox and haven't been active in 30 days.
Dominic Peterson 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 2 years ago in Microsoft 365 0

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 2 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 over 3 years ago in Microsoft 365 5

Microsoft 365: Maximum Secure Score

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