Exchange Administration
This page is dedicated to any and all Exchange Administration related content I can share.
Use the following to import an Exchange Online PSSession:
PS C:\> $credential = Get-Credential # opens prompt to collect credentials
PS C:\> $session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $credential -Authentication Basic -AllowRedirection
PS C:\> Import-PSSession $session
To bulk disable IMAP, POP3, and OWA, you can just select all mailboxes and disable the features (you cannot bulk-disable "OWA on Devices" of "SMTP Client Authentication" mailbox features using the web portal).
Therefore, it's best to use PowerShell ensure you disable anything unused (MAPI and ActiveSync are left enabled with this command):
Get-CASMailbox | Set-CASMailbox -PopEnabled:$False -ImapEnabled:$False -OWAEnabled:$False -SmtpClientAuthenticationDisabled:$True -OWAForDevicesEnabled:$False
Turning off SMTP Authentication globally (instead of per-mailbox) can be achieved by modifying the Transport configuration:
Set-TransportConfig -SmtpClientAuthenticationDisabled $True
Turning off IMAP and POP3 by default for new mailboxes can be done with a Client Access Service Plan modification (ensure you run the command above to disable anything that has previously been enabled!):
Get-CASMailboxPlan | Set-CASMailboxPlan -PopEnabled:$False -ImapEnabled:$False
$users = Get-Mailbox; ForEach ($user in $users) { Get-InboxRule -Mailbox $user.name | Select MailboxOwnerId,Name,Description | fl }
Listing the connection filter IP blocklist:
Get-HostedConnectionFilterPolicy -Identity Default | Select-Object -ExpandProperty IPBlockList
Get a total count of messages in your queue(s):
Get-ExchangeServer | Where {$.IsHubTransportServer -eq "true"} | Get-Queue | Where {$_.Deliverytype -eq "MapiDelivery"} | Select-Object Identity, NextHopDomain, Status, MessageCountChecking the outbox of your users' mailbox is also a good indicator to see if messages are stuck going outbound:
Get-Mailbox -resultsize unlimited | Get-MailboxFolderStatistics -folderscope outbox | Sort-object foldersize -Descending | Select-Object Identity,Name,Foldertype,itemsinfolder,@{Name="FolderSize MB";expression={$_.folderSize.toMB()}}Get-Mailbox -ResultSize unlimited | Format-Table Name,MaxSendSize,MaxReceiveSizeUse the following to export a mailbox to a .PST file:
New-MailboxExportRequest -Mailbox user -FilePath "\\fileserver\mailboxgraveyard\user.pst"Track the progress of your export request with:
Get-MailboxExportRequestGet a list of the currently connected databases (
Get-MailboxDatabase) and use the following command to see if there are any disconnected mailboxes:Get-MailboxStatistics -Database "<DB NAME>" | Where-Object {$_.DisconnectDate -Notlike $NULL} | FL DisplayName, DisconnectDate, MailboxGuidOnce you have a mailbox you wish to remove, use the following command to permantenly remove it:
Remove-Mailbox -Database "<DB NAME>" -StoreMailboxIdentity <MAILBOXGUID>Here is a useful command to get user information for a given mailbox while sorting the output by the total size:
Get-MailboxDatabase | Get-MailboxStatistics | Select DisplayName, LastLoggedOnUserAccount, ItemCount, TotalItemSize, LastLogonTime, LastLogoffTime | Sort-Object TotalItemSize -Descending | Export-CSV C:\temp\mailboxes.csvUse the following to get a CSV output of the Message Tracking logs based on a few basic parameters. This is a good way to track individual emails that fail to flow properly:
Get-MessageTrackingLog -Recipients:[email protected] -Start "3/1/2018 1:00:00 AM" -End "3/14/2018 11:00:00 PM" | Select {$_.Recipients}, {$_.RecipientStatus}, * | Export-Csv C:\temp\user-emails.csvList all ActiveSync devices and the corresponding mailbox/user:
Get-ActiveSyncDevice | Select-Object DeviceModel,FriendlyName,DeviceOS,UserDisplayName,Identity | Sort-Object DeviceModel | Export-CSV -Path C:\temp\activesyncusers.csvYou can get a list of devices by username with the following:
Get-ActiveSyncDeviceStatistics -Mailbox:"username" | Select-Object Guid,Identity,DeviceModel,LastSuccessSync | Sort-Object LastSuccessSyncIf you want to delete one, you can simply:
Remove-ActiveSyncDevice <GUID>You can do this by running a command that will check for any device that have not sync'd in over 365 days. Generate this list with the following:
$OldDevices = Get-ActiveSyncDevice -ResultSize unlimited | Get-ActiveSyncDeviceStatistics | where {$_.LastSyncAttemptTime -lt (Get-Date).AddDays(-365)}And to remove them completely, you can use this:
$OldDevices | foreach-object { Remove-ActiveSyncDevice([string]$_.Guid) -confirm:$false }You can also take a look at a script I wrote to automate all of this. It will remove any ActiveSync devices that have not attempted to sync in 1 year, and it will also remove orphaned mobile devices (e.g. the mailbox doesn't exist or the user account is disabled). I run this quarterly to catch anything that might fall through the cracks.
I recommend that every once in a while, you check to see if OWA is enabled for users it doesn't have to be enabled for:
Get-CASMailbox | Where {$_.OWAEnabled} | ft DisplayName,OwaEnabledYou can disable it on a per-user basis:
Set-CASMailbox -Identity appledeveloper -OWAEnabled $falseOr you can disable it against all mailboxes with:
$mbxs = Get-Mailbox; foreach ($mbx in $mbxs) { Set-CASMailbox -Identity $($mbx.Alias) -OWAEnabled $false }