Report on selected O365 Security Group and its membership
under consideration
Steve
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
D
Dani Weisz
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]