Skip to Main Content
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.

Categories Auvik
Created by Phil at Gradient MSP
Created on Dec 13, 2022

Auvik: Count of 1 for Managed Network

Return a count of 1 for reconciling Managed Network services. As long as there is a managed switch, router or firewall, the result is 1. This is so you can set the list price of the product within your PSA and keep track of these Managed Network services in Synthesize Billing.

Query

Devices[?(attributes.deviceType == 'switch'||attributes.deviceType == 'l3Switch'||attributes.deviceType == 'router'||attributes.deviceType == 'firewall')&&attributes.onlineStatus=='online'] | to_number(`1`)


  • Attach files