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 917

Microsoft 365: Helpdesk Administrator Role User List

Provides a list of users who belong to the Helpdesk Administrator role. Setting up a report against this metric will allow you to audit the current user list across all of your customers. Additionally, creating an Alert to use the "changed" condit...
Paul Taplett over 1 year ago in Microsoft 365 0

Microsoft 365: Conditional Access Administrator Role User List

Provides a list of users who belong to the Conditional Access Administrator role. Setting up a report against this metric will allow you to audit the current user list across all of your customers. Additionally, creating an Alert to use the "chang...
Paul Taplett over 1 year ago in Microsoft 365 0

Microsoft 365: Security Administrator Role User List

Provides a list of users who belong to the Security Administrator role. Setting up a report against this metric will allow you to audit the current user list across all of your customers. Additionally, creating an Alert to use the "changed" condit...
Paul Taplett over 1 year ago in Microsoft 365 0

Microsoft 365: Security Score as Percentage

This metric returns a tenant's Microsoft 365 security score as a percentage of points available. It is an integer, but if you want it to a couple of decimal places, simply remove the ceil function.
Guest about 2 years ago in Microsoft 365 2

Microsoft 365: Exchange Licensed user w/ mailbox 95% full

Returns a list of users who are licensed for Exchange and who's mailbox storage used is >95%
Lamont Largie about 1 year ago in Microsoft 365 0

Microsoft 365: Consumed License Count by Product Name

Returns the count of consumed licenses by product. A useful metric when reconciling services in the Gradient MSP billing module.
Phil at Gradient MSP about 2 years ago in Microsoft 365 0

Microsoft 365: Unused License Count by Product Name

Returns the count of unused licenses by product. A useful metric when reconciling services in the Gradient MSP billing module.
Phil at Gradient MSP about 2 years ago in Microsoft 365 0

Microsoft 365: Users with "XX" License (List or Count)

This will allow you to pull a list of users or the count that is assigned to a specific License.
De'Shard Brown about 1 year ago in Microsoft 365 0

Microsoft 365: Current Secure Score

Reports the current Microsoft 365 Secure Score
Paul Taplett over 2 years ago in Microsoft 365 0

Office 365: Non-Admin Users with MFA Disabled 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...
Addison Caldwell over 3 years ago in Microsoft 365 1