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 910

Office 365: Filter licensed users with roar exclusion group

Useful for excluding accounts that may trigger on the default O365 disabled users report which may still be licensed for a specific reason. Will need to create a 'RoarExclude' object in O365 tenancy.
Joshua Demianeuk about 2 years 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 about 3 years ago in Microsoft 365 4

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

Office 365: Active Email List (Members Only)

This metric pulls a list of active emails and excludes any guest email addresses. Useful for Identity Monitoring inspector if you want to exclude guest accounts.
Andy Althouse over 2 years ago in Microsoft 365 0

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

Office 365: Disabled Users with active E3 Licensing

Will show any users who are disabled that still have an active E3 license that likely does not need to be assigned.
Nick Dechnik about 3 years ago in Microsoft 365 1

Microsoft 365 Privileged Users Not Logged in Last 30 Days

Microsoft 365 Privileged Users Not Logged in Last 30 Days
Guest over 2 years ago in Microsoft 365 0