Forum Discussion
List external users and their status
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.
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.
This is an old thread, but I needed to solve the same problem today and figured it would be good since I came across this thread looking for a solution to document what I came up with here. Hopefully it will be helpful for the next person. I used the Azure CLI and queried the userState property to identify guest accounts that had not had accepted the invitation. Here is the command I used:
az ad user list --query "[?userState == 'PendingAcceptance'].{userType:userType, surname:surname, givenName:givenName, department:department, userState:userState}" --output table
