Group membership

Every account and the teams and Microsoft 365 groups it's a member of. Only teams and Microsoft 365 groups are included. Security groups and distribution lists aren't, because Office Sentry doesn't read their members.

Account	Name	Account status	Teams and groups	Member of
aaron.watson@northwindtraders.example	Aaron Watson	Enabled	0
accounts@hollis-partners.example		Not in the user list	2	Clients, Finance
alfie.roberts@northwindtraders.example	Alfie Roberts	Enabled	0
alfie.scott@northwindtraders.example	Alfie Scott	Enabled	1	Operations
amelia.watson@northwindtraders.example	Amelia Watson	Enabled	2	Finance, Operations
ann.patel@northwindtraders.example	Ann Patel	Enabled	8	Board, Clients + 6 more Board Clients Finance Marketing Marketing Operations Provisioned Sales
arthur.evans@northwindtraders.example	Arthur Evans	Enabled	1	Finance
ella.baker@northwindtraders.example	Ella Baker	Enabled	1	Operations
breakglass@northwindtraders.example	Emergency access	Enabled	0
ethan.green@northwindtraders.example	Ethan Green	Enabled	1	Marketing
george.roberts@northwindtraders.example	George Roberts	Enabled	3	Clients, Finance, Marketing
george.robinson@northwindtraders.example	George Robinson	Enabled	0
grace.taylor@northwindtraders.example	Grace Taylor	Enabled	2	Clients, Marketing
grace.wilson@northwindtraders.example	Grace Wilson	Enabled	0
hannah.patel@northwindtraders.example	Hannah Patel	Enabled	2	Finance, Marketing
hannah.robinson@northwindtraders.example	Hannah Robinson	Enabled	3	Clients, Finance, Operations
harry.lee@northwindtraders.example	Harry Lee	Enabled	2	Clients, Finance
imogen.edwards@northwindtraders.example	Imogen Edwards	Enabled	1	Clients
isla.evans@northwindtraders.example	Isla Evans	Enabled	0
j.okafor@brightpath-consulting.example		Not in the user list	1	Clients
jacob.hughes@northwindtraders.example	Jacob Hughes	Enabled	1	Finance
lee_partner.org#EXT#@northwindtraders.onmicrosoft.com		Not in the user list	1	Project Phoenix
leo.evans@northwindtraders.example	Leo Evans	Enabled	2	Clients, Finance
leo.morris@northwindtraders.example	Leo Morris	Enabled	2	Finance, Marketing
leo.wright@northwindtraders.example	Leo Wright	Enabled	3	Finance, Marketing, Operations
maya.martin@northwindtraders.example	Maya Martin	Enabled	0
megan.lee@northwindtraders.example	Megan Lee	Enabled	1	Marketing
mia.hughes@northwindtraders.example	Mia Hughes	Enabled	1	Operations
olivia.scott@northwindtraders.example	Olivia Scott	Enabled	2	Finance, Operations
olivia.smith@northwindtraders.example	Olivia Smith	Enabled	0
owen.taylor@northwindtraders.example	Owen Taylor	Enabled	2	Clients, Marketing
owen.white@northwindtraders.example	Owen White	Enabled	0
pat@supplier.example		Not in the user list	2	Project Phoenix, Sales
rhys.clark@northwindtraders.example	Rhys Clark	Enabled	1	Operations
rhys.moore@northwindtraders.example	Rhys Moore	Enabled	0
robert.hughes@northwindtraders.example low	Robert Hughes	Disabled	2	Marketing, Project Phoenix
ruby.hill@northwindtraders.example	Ruby Hill	Enabled	2	Clients, Operations
ruby.taylor@northwindtraders.example	Ruby Taylor	Enabled	1	Finance
g#EXT#@northwindtraders.example	Sam Carter (guest)	Enabled	0
sophie.smith@northwindtraders.example	Sophie Smith	Enabled	0
thomas.clarke@northwindtraders.example	Thomas Clarke	Enabled	2	Finance, Marketing
zara.jackson@northwindtraders.example	Zara Jackson	Enabled	2	Marketing, Operations

Every team and Microsoft 365 group and the accounts in it.

Name	Team	Visibility	Owners	Members	Member list	Guests
Board	Yes	Private	Ann Patel	2	ann.patel@northwindtraders.example, 1 other member (groups, devices or contacts)
Clients	Yes	Private	Ann Patel, Grace Taylor	11	accounts@hollis-partners.example, ann.patel@northwindtraders.example + 9 more accounts@hollis-partners.example ann.patel@northwindtraders.example george.roberts@northwindtraders.example grace.taylor@northwindtraders.example hannah.robinson@northwindtraders.example harry.lee@northwindtraders.example imogen.edwards@northwindtraders.example j.okafor@brightpath-consulting.example leo.evans@northwindtraders.example owen.taylor@northwindtraders.example ruby.hill@northwindtraders.example	accounts@hollis-partners.example, j.okafor@brightpath-consulting.example
Finance	No	Private	Ann Patel, Thomas Clarke	15	accounts@hollis-partners.example, amelia.watson@northwindtraders.example + 13 more accounts@hollis-partners.example amelia.watson@northwindtraders.example ann.patel@northwindtraders.example arthur.evans@northwindtraders.example george.roberts@northwindtraders.example hannah.patel@northwindtraders.example hannah.robinson@northwindtraders.example harry.lee@northwindtraders.example jacob.hughes@northwindtraders.example leo.evans@northwindtraders.example leo.morris@northwindtraders.example leo.wright@northwindtraders.example olivia.scott@northwindtraders.example ruby.taylor@northwindtraders.example thomas.clarke@northwindtraders.example	accounts@hollis-partners.example
Marketing	No	Private	Robert Hughes (disabled)	12	ann.patel@northwindtraders.example, ethan.green@northwindtraders.example + 10 more ann.patel@northwindtraders.example ethan.green@northwindtraders.example george.roberts@northwindtraders.example grace.taylor@northwindtraders.example hannah.patel@northwindtraders.example leo.morris@northwindtraders.example leo.wright@northwindtraders.example megan.lee@northwindtraders.example owen.taylor@northwindtraders.example robert.hughes@northwindtraders.example thomas.clarke@northwindtraders.example zara.jackson@northwindtraders.example
Marketing	No	Public	None	1	ann.patel@northwindtraders.example
Operations	Yes	Private	Hannah Robinson	11	alfie.scott@northwindtraders.example, amelia.watson@northwindtraders.example + 9 more alfie.scott@northwindtraders.example amelia.watson@northwindtraders.example ann.patel@northwindtraders.example ella.baker@northwindtraders.example hannah.robinson@northwindtraders.example leo.wright@northwindtraders.example mia.hughes@northwindtraders.example olivia.scott@northwindtraders.example rhys.clark@northwindtraders.example ruby.hill@northwindtraders.example zara.jackson@northwindtraders.example
Project Phoenix	Yes	Public	Robert Hughes (disabled)	3	lee_partner.org#EXT#@northwindtraders.onmicrosoft.com, pat@supplier.example, robert.hughes@northwindtraders.example	lee_partner.org#EXT#@northwindtraders.onmicrosoft.com, pat@supplier.example
Provisioned	No	Private	Provisioning app (app)	1	ann.patel@northwindtraders.example
Sales	Yes	Private	Ann Patel, Eve Sinclair	3	ann.patel@northwindtraders.example, pat@supplier.example, 1 other member (groups, devices or contacts)	pat@supplier.example

One row per person per team or group, to filter and pivot in Excel.

Account	Name	Type	Account status	Team or group	Team	Owner
accounts@hollis-partners.example		Guest	Not in the user list	Clients	Yes	No
accounts@hollis-partners.example		Guest	Not in the user list	Finance	No	No
alfie.scott@northwindtraders.example	Alfie Scott	Member	Enabled	Operations	Yes	No
amelia.watson@northwindtraders.example	Amelia Watson	Member	Enabled	Finance	No	No
amelia.watson@northwindtraders.example	Amelia Watson	Member	Enabled	Operations	Yes	No
ann.patel@northwindtraders.example	Ann Patel	Member	Enabled	Board	Yes	Yes
ann.patel@northwindtraders.example	Ann Patel	Member	Enabled	Clients	Yes	Yes
ann.patel@northwindtraders.example	Ann Patel	Member	Enabled	Finance	No	Yes
ann.patel@northwindtraders.example	Ann Patel	Member	Enabled	Marketing	No	No
ann.patel@northwindtraders.example	Ann Patel	Member	Enabled	Marketing	No	No
ann.patel@northwindtraders.example	Ann Patel	Member	Enabled	Operations	Yes	No
ann.patel@northwindtraders.example	Ann Patel	Member	Enabled	Provisioned	No	No
ann.patel@northwindtraders.example	Ann Patel	Member	Enabled	Sales	Yes	Yes
arthur.evans@northwindtraders.example	Arthur Evans	Member	Enabled	Finance	No	No
ella.baker@northwindtraders.example	Ella Baker	Member	Enabled	Operations	Yes	No
ethan.green@northwindtraders.example	Ethan Green	Member	Enabled	Marketing	No	No
george.roberts@northwindtraders.example	George Roberts	Member	Enabled	Clients	Yes	No
george.roberts@northwindtraders.example	George Roberts	Member	Enabled	Finance	No	No
george.roberts@northwindtraders.example	George Roberts	Member	Enabled	Marketing	No	No
grace.taylor@northwindtraders.example	Grace Taylor	Member	Enabled	Clients	Yes	Yes
grace.taylor@northwindtraders.example	Grace Taylor	Member	Enabled	Marketing	No	No
hannah.patel@northwindtraders.example	Hannah Patel	Member	Enabled	Finance	No	No
hannah.patel@northwindtraders.example	Hannah Patel	Member	Enabled	Marketing	No	No
hannah.robinson@northwindtraders.example	Hannah Robinson	Member	Enabled	Clients	Yes	No
hannah.robinson@northwindtraders.example	Hannah Robinson	Member	Enabled	Finance	No	No
hannah.robinson@northwindtraders.example	Hannah Robinson	Member	Enabled	Operations	Yes	Yes
harry.lee@northwindtraders.example	Harry Lee	Member	Enabled	Clients	Yes	No
harry.lee@northwindtraders.example	Harry Lee	Member	Enabled	Finance	No	No
imogen.edwards@northwindtraders.example	Imogen Edwards	Member	Enabled	Clients	Yes	No
j.okafor@brightpath-consulting.example		Guest	Not in the user list	Clients	Yes	No
jacob.hughes@northwindtraders.example	Jacob Hughes	Member	Enabled	Finance	No	No
lee_partner.org#EXT#@northwindtraders.onmicrosoft.com		Guest	Not in the user list	Project Phoenix	Yes	No
leo.evans@northwindtraders.example	Leo Evans	Member	Enabled	Clients	Yes	No
leo.evans@northwindtraders.example	Leo Evans	Member	Enabled	Finance	No	No
leo.morris@northwindtraders.example	Leo Morris	Member	Enabled	Finance	No	No
leo.morris@northwindtraders.example	Leo Morris	Member	Enabled	Marketing	No	No
leo.wright@northwindtraders.example	Leo Wright	Member	Enabled	Finance	No	No
leo.wright@northwindtraders.example	Leo Wright	Member	Enabled	Marketing	No	No
leo.wright@northwindtraders.example	Leo Wright	Member	Enabled	Operations	Yes	No
megan.lee@northwindtraders.example	Megan Lee	Member	Enabled	Marketing	No	No
mia.hughes@northwindtraders.example	Mia Hughes	Member	Enabled	Operations	Yes	No
olivia.scott@northwindtraders.example	Olivia Scott	Member	Enabled	Finance	No	No
olivia.scott@northwindtraders.example	Olivia Scott	Member	Enabled	Operations	Yes	No
owen.taylor@northwindtraders.example	Owen Taylor	Member	Enabled	Clients	Yes	No
owen.taylor@northwindtraders.example	Owen Taylor	Member	Enabled	Marketing	No	No
pat@supplier.example		Guest	Not in the user list	Project Phoenix	Yes	No
pat@supplier.example		Guest	Not in the user list	Sales	Yes	No
rhys.clark@northwindtraders.example	Rhys Clark	Member	Enabled	Operations	Yes	No
robert.hughes@northwindtraders.example	Robert Hughes	Member	Disabled	Marketing	No	Yes
robert.hughes@northwindtraders.example	Robert Hughes	Member	Disabled	Project Phoenix	Yes	Yes
ruby.hill@northwindtraders.example	Ruby Hill	Member	Enabled	Clients	Yes	No
ruby.hill@northwindtraders.example	Ruby Hill	Member	Enabled	Operations	Yes	No
ruby.taylor@northwindtraders.example	Ruby Taylor	Member	Enabled	Finance	No	No
thomas.clarke@northwindtraders.example	Thomas Clarke	Member	Enabled	Finance	No	Yes
thomas.clarke@northwindtraders.example	Thomas Clarke	Member	Enabled	Marketing	No	No
zara.jackson@northwindtraders.example	Zara Jackson	Member	Enabled	Marketing	No	No
zara.jackson@northwindtraders.example	Zara Jackson	Member	Enabled	Operations	Yes	No

By person 42

By team or group 9

Every membership 57