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 Subscribe
Categories Sophos Central
Created by Phil at Gradient MSP
Created on Jun 1, 2022

RELATED METRIC

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

Returns the number of servers 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.


Query

Endpoints[?type == `server`] || Endpoints[].assignedProducts[?code == 'coreAgent' && 'interceptX'] | length(@)

  • Attach files
  • Erik Zwep
    Reply
    |     Jul 18, 2022

    Forget my comment, the query was the same, it just works.

  • Erik Zwep
    Reply
    |     Jul 18, 2022

    The above query does not work for me. This one does:
    Endpoints[?type == `server`] || Endpoints[].assignedProducts[?code == 'coreAgent' && 'interceptX'] | length(@)