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

Windows Server | Self Signed certificates expiring within 30 days List

Using new roarpath functions, shows when self signed certs are expiring within 30 days or less
Stephen Rankich over 2 years ago in Windows Server 0

Azure: Network Security Group - Open RDP

This query is used to find Azure Network Security Groups that have a rule which allows access to port 3389 (RDP) from any source (*). The query returns the name of any security groups that have this rule. Leaving RDP (Remote Desktop Protocol) expo...
William Martin over 1 year ago in Azure 0

Amazon Web Services: Unattached Elastic IP Addresses Count

Returns a count of the number of unassociated Elastic IPs from an AWS account. Removing unused Elastic IP addresses will reduce billing costs.
Greg Russo over 1 year ago in Amazon Web Services 0

TLS/SSL: Certificates Expiring in 30 days (Excluding Let's Encrypt)

Returns the SCN of certificates that are not issued by Let's Encrypt and have an expiration of less than or equal to 30 days.
Dominic Peterson 10 months ago in TLS/SSL Certificates 0

Azure: Windows servers missing Hybrid Benefits

This metric lists all Windows virtual machines that have a null licenseType property. A null licenseType property indicates that the Hybrid Benefits are not applied to the virtual machine. This presents an opportunity for cost savings by providing...
William Martin over 1 year ago in Azure 0

NYCCD-SQL17 - SA Members

Queries the SQL Server to poll the Server Role Members with SA privileges
Guest 11 months ago in SQL Server 0

Windows: Roles

This is helpful to someone who's trying to obtain/maintain visibility into the available roles local to a Windows server. This is a good Metric for QBRs, recurring site reviews, and an onboarding report. Also, this Metric could be used to build an...
Addison Caldwell over 3 years ago in Windows Server 1

Internet Domain/DNS: Email Hosting Vendor

This is helpful to someone who's trying to obtain/maintain visibility into the email hosting vendor associated with a domain. This is a good Metric for QBRs, recurring site reviews, and an onboarding report. Also, if your MSP resells M365, this Me...
Addison Caldwell over 3 years ago in Internet Domain/DNS 0

Cisco Umbrella: Count of Devices

This is helpful to someone who's trying to obtain/maintain visibility into the count of devices in an organization's Meraki instance. This is a good Metric for QBRs or recurring site reviews.
Addison Caldwell over 3 years ago in Cisco Umbrella 1

Active Directory: Groups w/ Users

This is helpful to someone who's trying to obtain/maintain visibility into the groups at an organization and which users are a part of them. This is a good Metric for QBRs or recurring site reviews. Also, this Metric could be used to build a user ...
Addison Caldwell over 3 years ago in Active Directory 0