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 SentinelOne
Created by Phil at Gradient MSP
Created on Jun 1, 2022

RELATED METRIC

SentinelOne: Count of Active Licenses of Singularity Control

Returns the number of active licenses for SentinelOne Singularity Control. Add a different sku to return other licenses. This is a useful metric when reconciling services in the Gradient MSP billing module.


Query

SystemInfo.activeLicenses || sku == 'Control'


Update use the following query instead:

to_number(SystemInfo.sku == `Control` && ~.SystemInfo.totalLicenses | replace(to_string(@), to_string(`false`), to_string(`0`)))



  • Attach files
      Drop here to upload
    • Devon
      Reply
      |       Apr 17, 2023

      This will return the total count available not the current active count.


      Update Metric to
      to_number(SystemInfo.sku == `Control` && ~.SystemInfo.activeLicenses | replace(to_string(@), to_string(`false`), to_string(`0`)))

      For complete change Control to Complete

    • Phil at Gradient MSP
      Reply
      |       Aug 10, 2022

      To return false or 'null' query results to a 0 try:

      to_number(SystemInfo.sku == `Control` && ~.SystemInfo.totalLicenses | replace(to_string(@), to_string(`false`), to_string(`0`)))

    • Phil at Gradient MSP
      Reply
      |       Aug 10, 2022

      to_number(SystemInfo.sku == `Control` && ~.SystemInfo.totalLicenses | replace(to_string(@), to_string(`false`), to_string(`0`)))

    • Todd Smith
      Reply
      |       Jun 15, 2022

      This did not work for us. It pulled in qty's of Complete SKU also, and vice versa when we tried 'Complete'. Any ideas?