Finding all users without a specific alias

firemixtap3 · 2019-06-19T14:49:04.000Z

I have created the following script:

$Mailboxes = Get-Mailbox -Filter {Alias -notlike "*.onmicrosoft.com"} | Select-Object -Property displayname
$Mailboxes | sort | get-unique > $HOME\Desktop\Missing_Domain.txt

I am trying to create a script that will show all mailboxes in exchange without certain alias. This will be used to create a script that will add the alias on to each of the mailboxes. This is for a migration from exchange to Office 365.

the script to add everything looks like:

$Mailboxes = Get-Mailbox -Filter {Alias -notlike "*onmicrosoft.com"} | Select-Object -Property displayname
$Mailboxes | sort | get-unique > $HOME\Desktop\Missing_Domain.txt

$MissingDomain = Get-Content $HOME\Desktop\Missing_Domain.txt

ForEach ($MisDom in $MissingDomain) {
    
    $email = Get-Mailbox $MisDom | Select-Object -Property PrimarySmtpAddress

    $parts = $email.split("@")
    $parts[0] | Out-File $HOME\Desktop\output.txt -Append

    Set-Mailbox $MisDom -EmailAddresses @{add= $parts[0] + "@xxx.onmicrosoft.com"}
}

If you have any advice, have done this previously, or know that something in my scripts are incorrect. please let me know.

Neally · 2019-06-19T17:19:41.000Z

Welcome!

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

Neally · 2019-06-19T17:28:19.000Z

Firemixtap3:

If you have any advice, have done this previously, or know that something in my scripts are incorrect. please let me know.

So if you try to run your script it does not work? Do you get an error ? Can you elaborate?

firemixtap3 · 2019-06-19T17:47:48.000Z

WARNING: The object xxxxxxxx.com/Microsoft Exchange System Objects/SystemMailbox{D2305B72-C2DF-4611-95FA-9B896EE0BB3D} has been corrupted or isn’t compatible with Mic
rosoft support requirements, and it’s in an inconsistent state. The following validation errors happened:
WARNING: Database is mandatory on UserMailbox.
WARNING: Database is mandatory on UserMailbox.

Just ran the first two liner to see if it would output correctly. It gave me only one name

Neally · 2019-06-19T17:53:32.000Z

Firemixtap3:

WARNING: The object xxxxxxxx.com/Microsoft Exchange System Objects/SystemMailbox{D2305B72-C2DF-4611-95FA-9B896EE0BB3D} has been corrupted or isn’t compatible with Mic
rosoft support requirements, and it’s in an inconsistent state. The following validation errors happened:
WARNING: Database is mandatory on UserMailbox.
WARNING: Database is mandatory on UserMailbox.

Check if for the object there is valid DisplayName and msExchMailboxGuid attribute

Mailbox is corrupt or incompatible with Microsoft support requirements [RESOLVED] How to fix damaged or corrupt Health Mailbox on Exchange 2016 - admin-enclave

firemixtap3 · 2019-06-19T18:03:00.000Z

I think the filter method of get-mailbox is not properly pulling the information I want. I have tried using emailaddresses instead of Alias as I realized there is overlap in the naming scheme. Alias for the mailbox isn’t the same as an alias email address. I have also realized that -notlike does not get rid of the mailboxes I don’t want. Selecting the mailboxes that do not have the domain in them seems more difficult than originally anticipated.

tulioarends · 2019-06-20T17:55:05.000Z

Most user email aliases are not defined in the mailbox, but rather the ProxyAddresses property of the user.

If you sync your local AD to Office 365 you would use:

Get-AdUser username -Properties ProxyAddresses