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

My likes: Microsoft 365

Showing 123 of 917

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 over 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 over 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 over 1 year ago in Microsoft 365 0

Office 365: Licenses Consumed - Onedrive For Business (Plan 2)

This is helpful to someone who's trying to obtain/maintain visibility into a part of an organzation's M365 licensing breakdown. This is a good Metric for QBRs or recurring site reviews.
Addison Caldwell over 3 years ago in Microsoft 365 0

Office 365: Unassigned License Summary

This is helpful to someone who's trying to obtain/maintain visibility into unassigned licenses within an organization's M365 instance. This is a good Metric for QBRs, recurring site reviews, an onboarding report, and a licensing audit. This Metric...
Addison Caldwell over 3 years ago in Microsoft 365 0

Microsoft 365: Count of Active Users with Consumed Licenses

Count of active users with consumed licenses over multiple licenses.
Phil at Gradient MSP almost 2 years ago in Microsoft 365 0

Microsoft 365: Count of Active Users with Exchange

Returns the count of active users that have an Exchange license enabled.
Phil at Gradient MSP about 2 years ago in Microsoft 365 0

Microsoft 365: Total Licenses Consumed

Total licenses consumed.
Phil at Gradient MSP about 2 years ago in Microsoft 365 0

Microsoft 365: User Data Set

Microsoft 365 User Metric designed for Power BI consumption
Paul Taplett over 2 years ago in Microsoft 365 0

Microsoft 365: System Info Data Set

Microsoft 365 System Info Metric designed for Power BI consumption.
Paul Taplett over 2 years ago in Microsoft 365 0