List of Active Directory users who do not have a Exchange 2013 mailbox

powershell active-directory exchange-server exchange-server-2013
user6219126 picture user6219126 · May 17, 2016 · Viewed 7.7k times · Source

We delete users through Exchange 2013 which leaves behind the user account in Active Directory.

Using a PowerShell snippet, how can I get a list of Active Directory users who do not have a Exchange 2013 mailbox?

i.e. Active Directory users that need to be deleted.

Answer

Frode F. picture Frode F. · May 17, 2016

I'm confused. When you delete a mailbox in Exchange 2013, the AD user is also deleted. If you disable it the AD user is kept, but the attributes are removed. So if you really want to remove someone, why not delete the mailbox?

The primary difference between deleting and disabling a mailbox is that when you disable a mailbox, the Exchange attributes are removed from the corresponding Active Directory user account, but the user account is retained. When you delete a mailbox, both the Exchange attributes and the Active Directory user account are deleted.

Source: Disable or delete a mailbox @ TechNet

You could try to use the not-operator, ex:

Get-ADUser -LDAPFilter "(!msExchMailboxGuid=*)"

or

Get-ADUser -Filter '-not msExchMailboxGuid -like "*"'

or

Get-ADUser -Filter 'msExchMailboxGuid -notlike "*"'

Related questions

How to get all groups that a user is a member of?

PowerShell's Get-ADGroupMember cmdlet returns members of a specific group. Is there a cmdlet or property to get all the groups that a particular user is a member of? I fixed my mistake: Get-Member should be Get-ADGroupMember.

Read More
Powershell script to see currently logged in users (domain and machine) + status (active, idle, away)

I am searching for a simple command to see logged on users on server. I know this one : Get-WmiObject -Class win32_computersystem but this will not provide me the info I need. It returns : domain Manufactureer Model Name (Machine name) …

Read More
Converting LastLogon to DateTime format

My objective is to get a list of users from my domain with the following info: -Display name -Country -Manager Name -Last login date I am running the following script, and everything looks good except for the LastLogon. It outputs …

Read More