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 885

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

Visio Online (Plan 2) Assigned License Count
Matthew Waddell about 1 year ago in Microsoft 365 0

Microsoft 365: Return Additional Data via M365 Inspector (Checks the 365 concealed user, group, and site names in all reports Setting)

In order to return more data via the Microsoft 365 inspector, you need to disable the setting "Display concealed user, group, and site names in all reports" in the 365 tenancy (refer to Liongard documentation for more information). This metric wil...
Sam Walker over 2 years ago in Microsoft 365 2

Microsoft 365: Licenses set to expire within 30 days with no renewal list

You can use this metric to see which licenses are going to expire within 30 days that are not set to renew. It will also give you a count of how many of those licenses are in the warning state. Use the metric below to get a count of how many licen...
Stephen Rankich over 2 years ago in Microsoft 365 0

Office 365: Admin Users with MFA Disabled List

This is helpful to someone who's trying to obtain/maintain visibility into the 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 bui...
Addison Caldwell about 3 years ago in Microsoft 365 2

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

M365: Non-Admin Users with MFA Enabled 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...
De'Shard Brown almost 3 years ago in Microsoft 365 4

Microsoft 365: Count of Licenses by Product Name

Returns the number of licenses for a single skuPartNumber. Product names and service plan identifiers for Microsoft 365 licensing can be found here. Simply insert the skuPartNumber into the query. This is a useful metric when reconciling services ...
Phil at Gradient MSP about 2 years ago in Microsoft 365 0

Microsoft 365: Users w/ MFA Enabled Count

Counts the number of users with MFA enabled in the entire Environment. Useful for determining the rollout of MFA or reporting. Does not require the P1 license.
Zyad Khan about 2 years ago in Microsoft 365 1