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

All Metric entries

Showing 885 of 885

Active Directory: Password Never Expires = TRUE

This is helpful to someone who's trying to obtain/maintain visibility into a part of the breakdown of an AD password policy at an organization. This is a good Metric for QBRs, recurring site reviews, and an onboarding report. This Metric can also ...
Addison Caldwell about 3 years ago in Active Directory 0

Azure AD: Complete List of Conditional Access Policies and Excluded Users

This metric will return a complete list of Azure AD Conditional Access policies and a list of excluded users for each policy. This is difficult because the policies only contain a list of user's ID, not their display names.
David Chapman about 1 year ago in Azure Active Directory 1

Duo Security: Disabled Users

Grab all users who are showing as disabled.
Matthew Waddell over 1 year ago in Duo Security 0

Windows Workstation: Last Logged In User has Local Admin Permissions?

Identifies if the last logged in user is a member of the "Administrators" group. Returns 'true' or 'false'
Henri Pitkänen over 1 year ago in Windows Workstation 0

Windows Workstation: Is BitLocker Enabled on an OS Drive?

Identifies if BitLocker is enabled on an operating system drive. Returns 'true' or 'false'
Henri Pitkänen over 1 year ago in Windows Workstation 0

Microsoft 365: Nonprofit License Excluding Donated Licenses

Use this query when syncing nonprofit licenses. You can change the consumedUnits that are subtracted depending on the donated licenses.
Phil at Gradient MSP over 1 year ago in Microsoft 365 0

Microsoft 365: Licenced Mailbox User

Lists all users with a licenced mailbox (not all data prints can use the "?Has_Exchange_License == `True`" due to type of licence and graph permissions!!) Can be turned into a count with length(@) Can also separate enabled and disabled with "&...
Austin B [QuoStar] over 1 year ago in Microsoft 365 0

Microsoft 365: Maximum Secure Score

Returns the maximum secure score possible for the tenant.
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

Active Directory: Count of Users Assigned to Group(s)

Returns the number of users assigned to a group.
Erik Zwep almost 2 years ago in Active Directory 0