Liongard Ideas Portal

Submit and upvote ideas to make Liongard better. You get 20 votes so vote wisely. 🙂


The Product Team is constantly reading your ideas and while we can’t promise that all ideas will become a reality, we value your feedback and promise to always have our Partners in mind when building and improving Liongard.

Check out our FAQs to learn more.

See what we've shipped by clicking here!

Add Metric for - Microsoft 365: Licenses set to expire within 30 days with no renewal list

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


For alerting to count if the # of skus with a warning state is >0 use:


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


Below will give you back the list with context:


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


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


Please add this metric to the out of the box available metrics/alerts and add the metric to the M365 dashboard under the Licensing tab (If that's where it fits best)

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


  • Christopher Marquez
  • Mar 7 2022
  • Reviewed - Under Consideration
  • Attach files