Below are some of the single line PowerShell commands which will help
you routine Exchange tasks.
To find Deleted Mailboxes from Exchange Server:
Get-MailboxStatistics -Server Exch01| where { $_.DisconnectDate -ne
$null } | select DisplayName,DisconnectDate
To Change Primary SMTP for bulk Users:
Import-Csv "C:\Powershell\user.csv" | foreach {
Set-Mailbox $_.alias -PrimarySmtpAddress
("{0}.{1}@contoso.com" -f $_.firstname,$_.lastname)
-EmailAddressPolicyEnabled $false }
CSV file format:
Alias,Firstname,Lastname
Test.cloud,Test,Cloud
|
|
|
|
|
|
Provide Full Access Permission on multiple User Mailboxes for any Admin
Account:
Note: Paste the below command into TXT file and change the
file extension into .PS1 and run the .PS1 file into Exchange Management
Console.
-
$csv = import-csv "C:\Powershell\user.csv"
$csv | Foreach {
$Indentity = $_.ID
Add-MailboxPermission -Identity $_.ID -User TestAdmin -AccessRights
FullAccess
}
CSV File format:
Delete Bulk Exchange Public Folders:
Note: Paste the below command into TXT file and change the
file extension into .PS1 and run the .PS1 file into Exchange Management
Console.
-
$csv = import-csv
"C:\Powershell\Delete_BulkPublicFolder\Public.csv"
$csv | Foreach {
Remove-PublicFolder -id $_.id -confirm:$false
}
CSV file format:
Extract Exchange 2007 Active sync users list:
Get-Mailbox -ResultSize:Unlimited | ForEach
{Get-ActiveSyncDeviceStatistics -Mailbox:$_.Identity} |ft
identity,devicemodel,devicetype,LastSuccessSync >c:\user.csv
To get Exchange 2007 CAS server Certificate details:
Get-ExchangeCertificate | select thumbprint,
issuer, isselfsigned, services, notafter
Remove Certificate:
Remove-ExchangeCertificate -Thumbprint
15de8243s72gchb75h4d8108626674333d013f
ActiveSync policy applies to Bulk Users:
Import-CSV -Path
C:\Powershell\iphonepolicy.csv | % {Set-CASMailbox -Identity $_.Alias
-ActiveSyncMailboxPolicy (Get-ActiveSyncMailboxPolicy “iPhone Test policy”)}
CSV File Format:
Alias
Test.cloud
Test.active
To Create Bulk External Contacts:
Note: Paste the below command into TXT file and change the
file extension into .PS1 and run the .PS1 file into Exchange Management
Console.
$csv = import-csv D:\Powershell\Conatcts\Createcontacts3.csv
$csv | % {
new-mailcontact -name $_.name -Firstname $_.firstname -lastname
$_.lastname -alias $_.alias -externalemailaddress $_.external
-OrganizationalUnit $_.OUpath
Set-MailContact $name -HiddenFromAddressLists $Enabled
}
CSV File format:
name,firstname,lastname,alias,external,Oupath
Test Cloud,Test,Cloud,Test.Cloud,test.cloud@gmail.com,
OU=Test,OU=Conatcts,DC=Contoso,DC=com"
To Set multiple DOMAIN CONTRL in Exchange Server:
Set-ExchangeServer
-identity Exch01-DomainController dc01.domain.com -StaticDomainControllers
‘dc01.domain.com’,‘dc02.domain.com’ -StaticGlobalCatalogs ‘dc01.domain.com’,
dc02.domain.com’-StaticConfigDomainController ‘dc01.domain.com’,
‘dc02.domain.com’
To find Manual quota is defined or not for Bulk users:
Open a .txt file and copy the below command, save the file
as .ps1
-------------------------------------------------------------
$CSV = Import-Csv "C:\Powershell\quota.csv"
$csv | Foreach {
$Indentity = $_.Alias
get-mailbox -Identity $_.Alias | Where
{$_.UseDatabaseQuotaDefaults -eq $false}
}
------------------------------------------------------------
CSV Format:
Alias
Test.user
Test.user1
Get Database Quota Result for all Mailbox servers:
Get-MailboxDatabase
| Select-Object ServerName,Name,IssueWarningQuota,ProhibitSendQuota,ProhibitSendReceiveQuota
| Sort-Object Name | Export-Csv :\DatabaseLimits.csv –NoTypeInformation
Apply Quota for Bulk Database:
Copy below to TXT file and convert into .PS1
------------------------------------
$csv = import-csv
"C:\Powershell\DB\DB.csv"
$csv | Foreach {
Set-MailboxDatabase-Identity $_.DB
-IssueWarningQuota 900MB -ProhibitSendQuota 1024MB -ProhibitSendReceiveQuota
8192MB
}
-----------------------------------
CSV Format:
DB
MAIL1\SG1\MBXStore1
MAIL1\SG2\MBXStore2
MAIL1\SG3\MBXStore3
ActiveSync policy user list with Policyname and server
Get-CASMailbox
-Filter {ActiveSyncMailboxPolicy -eq $ActiveSyncPolicyName} |ft Displayname,
ActiveSyncMailboxPolicy, Servername
Search by ActiveSync Policy Name
Get-CASMailbox
-ResultSize 20000000 | where{$_.activesyncmailboxpolicy -match "ActiveSync
Without Device Password Policy"} | ft Displayname >d:\result.csv
Hope this helps.
Expect more!!
