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 123 of 918

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 : Malicious Application Consent - Padlet

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.
Jordan Docter 10 months ago in Microsoft 365 0

Microsoft 365: Maximum Secure Score

Returns the maximum secure score possible for the tenant.
Paul Taplett about 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 about 3 years ago in Microsoft 365 5

Microsoft 365: Active Email Addresses and Aliases by User (No Guest Accounts)

A list of emails addresses in use by user.
Kevin Fuller over 1 year 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 almost 3 years ago in Microsoft 365 2

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

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

Microsoft 365: Safe Attachments Enabled

Uses Microsoft 365 secure score to check if you meet the requirements for Safe Attachments. This means that the policies must be set to block. Provides True/False Response.
Jai Dametto almost 3 years ago in Microsoft 365 0