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 Microsoft 365
Created by Devon
Created on Nov 3, 2022

Microsoft 365: Exchange Licensed user w/ 95% full mailbox

Outputs percentage of Storage used against full mailbox size in addition to the email address and mailbox size.

Microsoft's built in warning to the user is at 98%, Prohibits sending at 99%, and Prohibits receiving at 100%. This can be customized by adjusting the number 95 to a relevant percentage.

Ex. [ 97.67, "%", "Person@domain.com" ]

Query

Users[?Has_Exchange_License == 'True' && (percent_of(to_number(Storage_Used), to_number(Prohibit_Send_and_Receive_Quota)) > '95') && to_number(Prohibit_Send_and_Receive_Quota) > '0' ].[percent_of(to_number(Storage_Used), to_number(Prohibit_Send_and_Receive_Quota)), '%', mail, slice_string(to_string(Prohibit_Send_and_Receive_Quota), '0,4')]

  • Attach files
  • Robert Slater
    Reply
    |
    Mar 17, 2023

    Not getting a return on this metric anymore, may have been nerfed by Microsoft's latest updates post March 1st.

  • Lamont Largie
    Reply
    |
    Jan 30, 2023

    This is a great metric! Thanks for sharing @Devon.