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 114 of 879

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

Microsoft 365: Microsoft Secure Scores List

Checks which Secure Scores are not 100% completed and displays a list of each with the current status of each. Useful for reporting. Example of what information is displayed: How many Admins have MFA enabled, The number of Global Admins, the numbe...
Zyad Khan almost 2 years ago in Microsoft 365 0

Microsoft 365: Licensing Data Set

Microsoft 365 Licensing Metric designed for Power BI consumption.
Paul Taplett almost 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 almost 3 years ago in Microsoft 365 1

Microsoft 365 | User Creation By Year

Using new roarpath function, get the creation year of users in M365
Stephen Rankich almost 2 years ago in Microsoft 365 0

Microsoft 365: Total Quantity of Licenses

Returns the total quantity of licenses (sum of consumed and unassigned licenses). Refer to the product plan identifiers for Product Friendly Names. Simply replace this to query other plans. https://learn.microsoft.com/en-us/azure/active-directory/...
Phil at Gradient MSP about 1 year ago in Microsoft 365 0

Microsoft 365: User Administrator Role User List

Provides a list of users who belong to the User 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" condition ...
Paul Taplett about 1 year ago in Microsoft 365 0

Microsoft 365: Global Administrator Role User List

Provides a list of users who belong to the Global 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" conditio...
Paul Taplett about 1 year ago in Microsoft 365 0

Microsoft 365: ATP Protection Secure Score

This Metric pulls back the percentage score of the ATP Protection Secure Score for turning on Safe Attachments. Microsoft Documentation A report can be created against this Metric to identify which customer have not ensured that the following glob...
Paul Taplett about 1 year ago in Microsoft 365 0

Microsoft 365: Users Search List [Power BI]

So this one is exactly the same as the original but it includes a helpful field: "Mailbox Type":userPurpose which returns values: user, shared or blank. This will allow a report to filter on Shared Mailboxes vs User Mailboxes.
Adam about 1 year ago in Microsoft 365 0