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 Stephen Rankich
Created on Mar 3, 2022

RELATED METRIC

Microsoft 365: Licenses set to expire within 30 days with no renewal list

You can use this metric to see which licenses are going to expire within 30 days that are not set to renew. It will also give you a count of how many of those licenses are in the warning state.

Use the metric below to get a count of how many license types are in a warning state for alerting and set the logic to > 0

Licensing[?prepaidUnits.warning > `0`].[skuPartNumber, `|` `Count of Licenses to Expire: `, prepaidUnits.warning] | length (@)

Query

Licensing[?prepaidUnits.warning > `0`].[skuPartNumber, `|` `Count of Licenses to Expire: `, prepaidUnits.warning]

  • Attach files