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 Microsoft 365
Created by Guest
Created on Sep 22, 2022

RELATED METRIC

Microsoft 365: Security Score as Percentage

This metric returns a tenant's Microsoft 365 security score as a percentage of points available. It is an integer, but if you want it to a couple of decimal places, simply remove the ceil function.

Query

ceil(percent_of(SecureScores.currentScore, SecureScores.maxScore)| to_number(@))
  • Attach files
  • Lamont Largie
    Reply
    |     Sep 25, 2023

    Some secure scores may not exist and as such a filter should be put in place to check that it exists.

    contains(SecureScores.controlScores[?controlName == `mdo_safelinksforemail` ].percent_of(to_number(count), to_number(total)), `100`)

  • Lamont Largie
    Reply
    |     Sep 25, 2023

    SecureScores.controlScores[?controlName == `UserRiskPolicy`].percent_of(to_number(count), to_number(total))