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!

Report on selected O365 Security Group and its membership

I have security groups that distinguish a email only user or a full managed seat user. Just seeing the users and licenses it too manual when you have a large tenant. For Accounting/billing/ invoicing purposes I would like to see a report that shows the Security Group I want and its members. It can be a metric and a report

  • Guest
  • Sep 10 2022
  • Reviewed - Under Consideration
Last Reviewed Date 2022-11-11
  • Attach files
  • Admin
    Daniela Weisz commented
    16 Nov 02:52pm

    Hey Steve, do these metric queries get you close to what data you'd like to capture?

    The first query will allow you to return the users for a specific Security Group.
    1. Groups.ActiveGroups[?displayName == `YourSecurityGroupName`].members[].[displayName, userPrincipalName]

    The second allows you to return the users for all Security Groups.

    2. Groups.ActiveGroups[?displayName].members[].[displayName, userPrincipalName]