To display mailboxes that are disconnected use the following command.
Replace
This gives a list of the disconnected mailboxes.
Get-MailboxStatistics -Server | where { $_.DisconnectDate -ne $null } | select DisplayName,DisconnectDate
To reconnect you use the command below
Connect-mailbox –database "mailbox database name" –Identity "disconnected mailbox name" –User "User to connect to"
select d.name, x1 =
(select X1= max(bb.xx)
from (
select xx = max(last_user_seek)
where max(last_user_seek) is not null
union all
select xx = max(last_user_scan)
where max(last_user_scan) is not null
union all
select xx = max(last_user_lookup)
where max(last_user_lookup) is not null
union all
select xx = max(last_user_update)
where max(last_user_update) is not null) bb)
FROM master.dbo.sysdatabases d
left outer join
sys.dm_db_index_usage_stats s
on d.dbid= s.database_id
group by d.name
After the deletion of a user with an mailbox this mailbox is left on the mailserver as an “disconnected mailbox”.
The process can take some time but can be started manual.
Start the “Exchange Management Shell”
Clean-MailboxDatabase “Your_Mailbox_Database_Name”
Set-MsolUserPrincipalName -UserPrincipalName [CurrentUPN] -NewUserPrincipalName [NewUPN]
Set-MailboxDatabase -CircularloggingEnabled:$true
Remember to re-disable it when done.
Set-MailboxDatabase -CircularloggingEnabled:$false
If you want to find a email address that is used in the organisation but you don’t know the mailbox it is linked to.
This works for aliases to.
[PS] C:\Windows\system32>Get-Recipient random.email@company.com
Name RecipientType
—- ————-
Test User UserMailbox
To create a list of all your email addresses including the primary and alias addresses run this PowerShell command;
Get-Mailbox -ResultSize Unlimited |Select-Object DisplayName,ServerName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}} | Export-CSV c:\smtp.csv -NoTypeInformation