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 Mason B-C
Created on Oct 20, 2024

RELATED METRIC

Microsoft 365: SharePoint Drives with Under 5GB Remaining in Quota List

Searches for SharePoint drives with less than 5GB of space remaining, excluding null results.
Returns the name of the drive, space remaining, and the drive's URL

Query

drives[?(quota.remaining < `10`)&&(quota.remaining !=`null`)].join(`, `,[name, join(`-`,[to_string( quota.remaining), `GB Remaining`]), webUrl])


  • Attach files
  • Scott Chatterji
    Reply
    |     Oct 21, 2024

    drives[?(quota.percentOfQuotaRemaining_r<= `10`) && (quota.remaining !=`null`)].[`GB Remaining`,'|', quota.remaining ,'|', `Share Point Site Name:`, webUrl]

    The above metric will provide a result for share point site or drive with drive space less than or equal to 10 percentage

    I corrected the flaws in the metirc you have posted above as it might provide a desired result