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

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 over 3 years ago in Microsoft 365 1

Sophos Central: Count of Workstations with Assigned Product(s)

Returns the number of workstations with assigned product(s). Add or remove assignedProducts to the query to report on specific configurations. This is a useful metric when reconciling services in the Gradient MSP billing module.
Phil at Gradient MSP over 2 years ago in Sophos Central 0

NinjaRMM: Count of Devices

Returns the number of managed devices. This is a useful metric when reconciling services in the Gradient MSP billing module.
Phil at Gradient MSP over 2 years ago in NinjaRMM 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 over 2 years ago in Microsoft 365 0

Continuum RMM: Count of Windows Workstations

Returns the number of Windows workstations. A useful metric when reconciling services in the Gradient MSP billing module.
Phil at Gradient MSP over 2 years ago in Continuum RMM 0

Auvik: Count of Online Firewalls, L3 Switches, Switches, Routers

Returns the count of all devices. Useful when reconciling services in the Gradient MSP billing module.
Phil at Gradient MSP over 2 years ago in Auvik 0

Acronis Cyber Cloud: Extra Cloud Storage (GB) Consumed

Extra Cloud Storage Consumed = Total Storage - (Mailbox Storage + VM Storage). Useful when obtaining extra cloud storage consumed (GB). Product usage you can use in the Gradient MSP billing module.
Phil at Gradient MSP over 2 years ago in Acronis Cyber Cloud 0

Sonicwall: Security Suite Licenses w/ Statuses

This Metric can be used to track licensing in a Sonicwall, as well as alert on changes to Sonicwall licensing status.
Addison Caldwell over 3 years ago in SonicWall 0

SQL Server: Product Name

Determines the product name to determine which version of SQL is installed.
Robbie Kibler over 3 years ago in SQL Server 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