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

SonicWall: Active Licenses Expiring in 90 days

This metric works for Gen 7 firewalls and returns a list of all active licenses that are going to expire in the next 90 days.
Justin Penchina 5 months ago in SonicWall 0

Azure Active Directory: Security Defaults & Conditional Access Policies Report

This report uses the Liongard API and pulls down the Security Defaults Status and Conditional Access Policies of all the Azure Active Directory Inspectors One benefit of this report is that you'll actually return the Display Names of the objects i...
Sam Walker 10 months ago in Azure Active Directory 0

Auvik: Count of Billable Devices

Pulls a count of what Auvik considers billable. https://support.auvik.com/hc/en-us/articles/203526850-What-counts-as-a-billable-device-
Leland Shane about 1 year ago in Auvik 0

Windows Workstation: Installed ThreatLocker Version

Displays the current version of ThreatLocker installed on a Windows Workstation
Lamont Largie about 1 year ago in Windows Workstation 0

Kaseya VSA: Server Count

Returns the number of servers to reconcile services in Synthesize Billing.
Phil at Gradient MSP over 1 year ago in Kaseya BMS 2

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

Azure Active Directory: "CA004: Require multifactor authentication for all users" policy

Identifies Conditional access policies which match Microsoft template of CA004: Require multifactor authentication for all users Great for security standards checks
Austin B [QuoStar] over 1 year ago in Azure Active Directory 0

Azure Active Directory: Shows AAD Members who don't have MFA Enforced (Includes Conditional Access Policies)

This looks for the registration being enabled on the account, rather than mfaregistrationstatus_r, making it take conditional access policies into account
Matt Scutt over 1 year ago in Azure Active Directory 0

IT Glue: List Users Who Haven't Signed In For More Than 90 Days

Returns a list of users who haven't signed in for more than 90 days. To only return Lite users (Or another specific type of user, add the following after the first "[": RoleName == `Lite` && Change the 90 to however many days you want to m...
Matt Scutt over 1 year ago in IT Glue 0

Active Directory: Distribution Lists

This pulls a list of distribution list names and excludes security groups as outlined here: https://docs.microsoft.com/en-us/powershell/module/activedirectory/new-adgroup?view=windowsserver2022-ps#:~:text=False-,%2DGroupCategory,-Specifies%20the%2...
Matt Scutt over 1 year ago in Active Directory 0