User accounts for Office 365 are stored in Azure Active Directory. The accounts will either be cloud identities, or synced identities. Cloud identities are accounts that exist only in Office 365/Azure AD, whereas synced identities are those that exist in an on-premises Active Directory and are being synchronized to Azure AD using a directory sync tool such as Azure AD Connect.
If you want to retrieve a list of synced and non-synced identities you can do so using the AzureAD PowerShell module. After connecting to Azure AD, use the Get-AzureADUser cmdlet to retrieve a list of users. You can group the users by the DirSyncEnabled property to get a count of synced and non-synced accounts.
|
1 2 3 4 5 6 7 8 |
PS C:\>Connect-AzureAD PS C:\> Get-AzureADUser | Group-Object -Property:DirSyncEnabled Count Name Group ----- ---- ----- 98 True {class User {... 2 {class User {... |
The first time I saw this I expected to see values of True and False, but instead it seems we get values of True and null. So, to retrieve a list of synced users, the command would be as follows:
|
1 |
PS C:\> Get-AzureADUser | Where {$_.DirSyncEnabled -eq $true} |
Here's an example where I've retrieved the DirSyncEnabled and LastDirSyncTime properties as well.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
PS C:\> Get-AzureADUser | Where {$_.DirSyncEnabled -eq $true} | Select -Property DisplayName,UserPrincipalName ,DirSyncEnabled,LastDirSyncTime | ft -auto DisplayName UserPrincipalName DirSyncEnabled LastDirSyncTime ----------- ----------------- -------------- --------------- Aaron Gardiner aaron.gardiner@exchangeserverpro.net True 10/19/2017 1:56:03 PM Adam Wally adam.wally@exchangeserverpro.net True 10/19/2017 1:56:03 PM Aisha Bhari Aisha.Bhari@exchangeserverpro.net True 10/19/2017 1:50:52 PM Alan Reid Alan.Reid@exchangeserverpro.net True 10/19/2017 1:56:03 PM Alannah Shaw Alannah.Shaw@exchangeserverpro.net True 10/19/2017 1:56:03 PM Aldith Walker Aldith.Walker@exchangeserverpro.net True 10/19/2017 1:52:08 PM Alex Heyne Alex.Heyne@exchangeserverpro.net True 10/19/2017 1:56:03 PM Alice Mullins Alice.Mullins@exchangeserverpro.net True 10/19/2017 1:53:24 PM Alison Pugh Alison.Pugh@exchangeserverpro.net True 10/19/2017 1:47:08 PM Almaz Duggan Almaz.Duggan@exchangeserverpro.net True 10/19/2017 1:56:02 PM ..... |
To retrieve a list of non-synced, or cloud-only identities, the command would be as follows:
|
1 2 3 4 5 6 |
PS C:\> Get-AzureADUser | Where {$_.DirSyncEnabled -eq $null} ObjectId DisplayName UserPrincipalName UserType -------- ----------- ----------------- -------- 8db8b044-b825-4456-b6f7-39... Paul Cunningham admin@exchangeserverpro.on... 00a77560-657b-44c3-9f38-08... Cloudy Room CloudyRoom@exchangeserverp... Member |
Paul is a Microsoft MVP for Office Apps and Services and a Pluralsight author. He works as a consultant, writer, and trainer specializing in Office 365 and Exchange Server.
Leave a Reply