Home

List external users and their status

%3CLINGO-SUB%20id%3D%22lingo-sub-91590%22%20slang%3D%22en-US%22%3EList%20external%20users%20and%20their%20status%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-91590%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20desperately%20need%20a%20way%20to%20list%20all%20external%20Azure%20AD%20users%20including%20their%20status%20(if%20they%20have%20accepted%20the%20invitation%20or%20not)%2C%20and%20it%20would%20be%20nice%20to%20be%20able%20to%20filter%20on%20domain.%20On%20TechNet%20I%20have%20found%20this%20PowerShell%20command%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3EGet-SPOExternalUser%20-Position%200%20-PageSize%2030%20-Filter%20%40testsite.com%3C%2FPRE%3E%3CP%3EIt%20doesn't%20work%20though%2C%20because%20it%20doesn't%20accept%20the%20%22%40%22%20and%20if%20I%20use%20the%20commend%20without%20filter%2C%20it%20doen't%20list%20information%20about%20the%20users%20invitational%20status.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20problem%20is%20that%20-PageSize%20can't%20exceed%2050%20-%20and%20we%20have%20hundreds%20of%20external%20users.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EJakob%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-91590%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20AD%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eexternal%20users%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-264986%22%20slang%3D%22en-US%22%3ERe%3A%20List%20external%20users%20and%20their%20status%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-264986%22%20slang%3D%22en-US%22%3E%3CP%3EThjat%20doesn't%20really%20cut%20it.%26nbsp%3B%20I%20need%20to%20see%20which%20guest%20users%20have%20activated%20their%20accounts%2C%20not%20look%20for%20invitations%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-92167%22%20slang%3D%22en-US%22%3ERe%3A%20List%20external%20users%20and%20their%20status%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-92167%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20check%20this%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FSet-up-and-manage-access-requests-94b26e0b-2822-49d4-929a-8455698654b3%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Earticle%3C%2FA%3E%26nbsp%3Bas%20it%20explains%20managing%20access%20requests%20and%20guest%20users%20with%20pending%20invitation.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-92040%22%20slang%3D%22en-US%22%3ERe%3A%20List%20external%20users%20and%20their%20status%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-92040%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Aljohn%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20gives%20me%20a%20list%20of%20all%20guest%20users.%20What%20I%20need%20is%20a%20list%20of%20only%20those%20guest%20users%20that%20have%20not%20yet%20accepted%20the%20invitation.%20Is%20that%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2FJakob%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-91615%22%20slang%3D%22en-US%22%3ERe%3A%20List%20external%20users%20and%20their%20status%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-91615%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F28745%22%20target%3D%22_blank%22%3E%40Jakob%20Rohde%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ea%20few%20years%20ago%20I%20battled%20with%20the%20same%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwp.me%2Fp1fg2Y-xTm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwp.me%2Fp1fg2Y-xTm%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20didn't%20get%20the%20full%20answer%20of%20your%20problem%20either%2C%20but%20at%20least%20I%20was%20able%20to%20get%20all%20of%20my%20active%20users.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-91595%22%20slang%3D%22en-US%22%3ERe%3A%20List%20external%20users%20and%20their%20status%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-91595%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20use%20the%20command%20below%20to%20get%20the%20list%20of%26nbsp%3B%3CSPAN%3Eall%20the%20Office%20365%20external%20users%20(guest%20users).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGet-MsolUser%20-All%20%7C%20%3F%20%7B%24_.UserType%20-eq%20%22Guest%22%7D%20%7C%20Select%20DisplayName%2CSignInName%20%7C%20FT%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20you%20can%20use%20this%20%3CA%20href%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2Foffice%2FList-and-Export-SharePoint-d670dc40%3FranMID%3D24542%26amp%3BranEAID%3DTnL5HPStwNw%26amp%3BranSiteID%3DTnL5HPStwNw-UeGsuHVz15i37o3DraMFLg%26amp%3Btduid%3D(de46bc9953f2b0d7119d9cd1ae9ce6a9)(256380)(2459594)(TnL5HPStwNw-UeGsuHVz15i37o3DraMFLg)()%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eapplication%3C%2FA%3E%26nbsp%3Bto%20list%20and%20export%20all%20external%20users%20to%20CSV.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

Hi all

 

I desperately need a way to list all external Azure AD users including their status (if they have accepted the invitation or not), and it would be nice to be able to filter on domain. On TechNet I have found this PowerShell command:

 

Get-SPOExternalUser -Position 0 -PageSize 30 -Filter @testsite.com

It doesn't work though, because it doesn't accept the "@" and if I use the commend without filter, it doen't list information about the users invitational status.

 

 

Another problem is that -PageSize can't exceed 50 - and we have hundreds of external users.

 

Any suggestions?

 

Thanks

Jakob

5 Replies

You can use the command below to get the list of all the Office 365 external users (guest users).

 

Get-MsolUser -All | ? {$_.UserType -eq "Guest"} | Select DisplayName,SignInName | FT

 

Also, you can use this application to list and export all external users to CSV.

Hi @Jakob Rohde,

 

a few years ago I battled with the same:

 

http://wp.me/p1fg2Y-xTm

 

I didn't get the full answer of your problem either, but at least I was able to get all of my active users.

 

 

 

 

Thanks Aljohn

 

This gives me a list of all guest users. What I need is a list of only those guest users that have not yet accepted the invitation. Is that possible?

 

/Jakob

You can check this article as it explains managing access requests and guest users with pending invitation.

Thjat doesn't really cut it.  I need to see which guest users have activated their accounts, not look for invitations etc.