Verify external user email registered in GCCH

Question

Verify external user email registered in GCCH

TN 101

We had an excel list of external users stored in our AD

For example

******@foodepot.com
john.doe@StEv .com
******@cncc.com
******@ggog.com

We need to run a report to indicate if these user email accounts already registered in their Azure AD GCC High tenant or not.

Thanks for your help.

JamesTran-MSFT 36,911 Reputation points Microsoft Employee Moderator

2021-12-21T22:17:39.163+00:00
@TN
Thank you for your post and I apologize for the delayed response!

When it comes to the list of external users, and checking if they've already registered within the Azure AD GCC High tenant, can you share some more info so I can gain a better understanding of your issue?

Do you have access to the Azure AD GCC High tenant?

Are these users supposed to register using the same email accounts?

When you say "we had an excel list of external users stored in our AD" are you referring to Active Directory, or Azure Active Directory?

How're you getting this list?

Any additional information or screenshots would be greatly appreciated.
Thank you again for your time and patience throughout this issue.
TN 101 Reputation points

2021-12-27T06:29:03.847+00:00

Thanks James, see my comments below:

Do you have access to the Azure AD GCC High tenant?

Yes I have access to Azure AD GCCH

Are these users supposed to register using the same email accounts?

Yes

When you say "we had an excel list of external users stored in our AD" are you referring to Active Directory, or Azure Active Directory?

These users stored in our on prem AD and we exported to Excel list

How're you getting this list?
These users stored in our on prem AD and we exported to Excel list

So basically the list of users we extracted from our on prem AD (SharePoint partner extranet) and stored in Excel. We need to run report from excel file against MS Azure AD to validate if those accounts above belong to their company GCCH or Commercial.

Regards,

1 answer

Your answer

JamesTran-MSFT 36,911 Reputation points Microsoft Employee Moderator

2021-12-21T22:17:39.163+00:00

@TN
Thank you for your post and I apologize for the delayed response!

When it comes to the list of external users, and checking if they've already registered within the Azure AD GCC High tenant, can you share some more info so I can gain a better understanding of your issue?

Do you have access to the Azure AD GCC High tenant?

Are these users supposed to register using the same email accounts?

When you say "we had an excel list of external users stored in our AD" are you referring to Active Directory, or Azure Active Directory?

How're you getting this list?

Any additional information or screenshots would be greatly appreciated.
Thank you again for your time and patience throughout this issue.
TN 101 Reputation points

2021-12-27T06:29:03.847+00:00

Thanks James, see my comments below:

Do you have access to the Azure AD GCC High tenant?

Yes I have access to Azure AD GCCH

Are these users supposed to register using the same email accounts?

Yes

When you say "we had an excel list of external users stored in our AD" are you referring to Active Directory, or Azure Active Directory?

These users stored in our on prem AD and we exported to Excel list

How're you getting this list?
These users stored in our on prem AD and we exported to Excel list

So basically the list of users we extracted from our on prem AD (SharePoint partner extranet) and stored in Excel. We need to run report from excel file against MS Azure AD to validate if those accounts above belong to their company GCCH or Commercial.

Regards,

Answer 1

@TN
Thank you for following up on this!

Since you're trying to see if the users from an Excel sheet exist within your GCCH tenant, have you look into the Get-AzureADUser PowerShell command? With Get-AzureADUser, you can filter with a SearchString, userPrincipalName, or by user ID. Additionally, you can also try Get-MsolUser since it offers more parameters to query with than Get-AzureADUser.

As of right now, I don't believe there's any feature within Azure AD that lets you run a report against an Excel file, to check if a user was created within your tenant from that file. However, if you'd like this feature to be implemented, I'd recommend leveraging our new User Voice forum and creating a feature request so our engineering team can take a closer look into this.

I've also added the windows-server-powershell tag so their community can look into this issue as well.

If you have any other questions, please let me know.
Thank you for your time and patience throughout this issue.

----------

Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

Share via

Verify external user email registered in GCCH

1 answer

Your answer