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 De'Shard Brown
Created on Oct 10, 2023

RELATED METRIC

Microsoft 365: Users with "XX" License (List or Count)

This will allow you to pull a list of users or the count that is assigned to a specific License.

Query

LIST:

Users[?contains(Assigned_Products,`Microsoft 365 Audio Conferencing`)].[`Name :` displayName , `| Email: ` mail]


Users[?contains(Assigned_Products,`Microsoft 365 Business Basic`)].[`Name :` displayName , `| Email: ` mail]


Users[?contains(Assigned_Products,`Microsoft 365 E3`)].[`Name :` displayName , `| Email: ` mail]


Users[?contains(Assigned_Products,`Microsoft 365 Business Standard`)].[`Name :` displayName , `| Email: ` mail]


Users[?contains(Assigned_Products,`Microsoft Flow Free`)].[`Name :` displayName , `| Email: ` mail]

COUNT:

Users[?contains(Assigned_Products,`Microsoft 365 Audio Conferencing`)] | length (@)


Users[?contains(Assigned_Products,`Microsoft 365 Business Basic`)] | length (@)


Users[?contains(Assigned_Products,`Microsoft 365 E3`)] | length (@)


Users[?contains(Assigned_Products,`Microsoft 365 Business Standard`)] | length (@)


Users[?contains(Assigned_Products,`Microsoft Flow Free`)] | length (@)
  • Attach files