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 904

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

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

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: 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 11 months 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 11 months 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 almost 2 years ago in Microsoft 365 2

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: Current Secure Score

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