Microsoft 365: Exchange Licensed user w/ 95% full mailbox
submitted
D
Devon Chorney
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" ]
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')]
R
Robert Slater
Not getting a return on this metric anymore, may have been nerfed by Microsoft's latest updates post March 1st.
L
Lamont Largie
This is a great metric! Thanks for sharing @Devon.