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 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 120 of 911

Microsoft 365 : Malicious Application Consent - PerfectData

This application has actively been used during account compromises to create a backup of the accounts mailbox.Create an actionable alert for this and audit all environments.
Devon over 1 year ago in Microsoft 365 1

M365: AAD App Secrets Expiring within 30 days

Looks for applications with expiring/expired secrets (within 30 days), then outputs the Application name, and the secrets associated that are expiring/expired.
Leland Shane over 1 year 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: 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 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

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

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: 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

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