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

Microsoft 365: Current Secure Score

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

Office 365: Global Admin Summary

Lists all explicit global admins Useful for distinguishing privileged roles from global admin Change sort(@) to length(@) to get a count Change == to != to identify privileged, but no global admin
Austin B [QuoStar] almost 2 years ago in Microsoft 365 0

Microsoft 365: Days till Liongard app registration expires

It will display the number of days you have till you need to create a new secret
Sam Mangum almost 2 years ago in Microsoft 365 0

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

Microsoft 365: User Data Set

Microsoft 365 User Metric designed for Power BI consumption
Paul Taplett 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