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 Joshua Demianeuk
Created on Jul 15, 2022

RELATED METRIC

Office 365: Filter licensed users with roar exclusion group

Useful for excluding accounts that may trigger on the default O365 disabled users report which may still be licensed for a specific reason. Will need to create a 'RoarExclude' object in O365 tenancy.

Query

Exception rule (Summary)

Users[?accountEnabled == `false` && assignedLicenses.length(@) > `0` && !contains(Groups, `RoarExclude`)].[userPrincipalName, Assigned_Products][]


Rule trigger (Count)

Users[?accountEnabled == `false` && assignedLicenses.length(@) > `0` && !contains(Groups, `RoarExclude`)] | length(@)
  • Attach files