Johnny Yao WorkSpace

  Index failed on MBX2 The timestamp of the catalog state is too old for database How to Rebuild the Full-Text Index Catalog http://technet.microsoft.com/en-us/library/aa995966(EXCHG.80).aspx   On MBX1 Index status of MBX1 Index status of MBX2 Update index from MBX1 to MBX2

  http://www.msdigest.net/2014/04/how-to-export-messages-from-a-mail-queue-on-exchange/   #Suspend all messages in the queue get-queue ExchangeServer\663 | Get-Message | Suspend-Message #Get all messages from the queue $array = @(Get-Message -Queue "ExchangeServer\663" -ResultSize unlimited) #Export all messages from the queu $array | ForEach-Object {$i++;Export-Message $_.Identity | AssembleMessage -Path ("E:\Mailqueue\"+ $i +".eml")}

  http://blogs.technet.com/b/aljackie/archive/2013/11/14/outlook-rpc-end-point-and-pf-the-microsoft-exchange-administrator-has-made-a-change-that-requires-you-quit-and-restart-outlook.aspx   http://www.msexchangegeek.com/the-microsoft-exchange-administrator-has-made-a-change-that-requires-you-quit-and-restart-outlook/   Exchange Team no longer recommend Windows NLB for Client Access Server Load Balancing http://www.stevieg.org/2010/11/exchange-team-no-longer-recommend-windows-nlb-for-client-access-server-load-balancing/   Outlook Intermittent Disconnections – Exchange 2010 http://exchangeserverinfo.net/2013/06/outlook-intermittent-disconnections-exchange-2010/ Troubleshooting Outlook RPC dialog boxes - revisited http://blogs.technet.com/b/exchange/archive/2008/05/02/3405434.aspx

  Update-FileDistributionService –Identity CAS_server –Type OAB

    rpcping -t ncacn_http -o Rpcproxy=qy-cas03.msft.corp.com -P "qy.user3,MSFT,MSFT8899" -H 1 -F 3 -a connect -u 9 -v 3 -s qy-mbx01.MSFT.corp.com -I "qy.user3,MSFT,MSFT8899" -e 6001

Default Client Access server IIS authentication and SSL settings http://technet.microsoft.com/en-us/library/gg247612(v=exchg.141).aspx

  http://community.office365.com/en-us/w/exchange/579.aspx     Get-Contact | Export-Csv c:\temp\contact.csv Get-MailContact | Export-Csv c:\temp\Mailcontact.csv   [PS] Import-Csv .\Contact_Source.csv | % {New-MailContact -Name $_.Name -DisplayName $_.DisplayName -ExternalEmailAddress $_.ExternalEmailAddress -Alias $_.Alias -PrimarySmtpAddress $_.PrimarySMTPAddress -OrganizationalUnit "Contacts" -WhatIf }   [PS] >$Contacts = Import-Csv .\Contact_final.csv [PS] >$Contacts | foreach {Set-Contact $_.Name -Company $_.Company -Department $_.Department -Office $_.Office -Phone $_.Phone }

    [PS] Get-Mailbox -organization Qisdaer -ResultSize unlimited |Where{($_.RecipientLimits -ne 'unlimited')} | f t Name, RecipientLimits [PS] Get-Mailbox -organization Qisdaer -ResultSize unlimited |Where{($_.MaxSendSize -ne 'unlimited')} | ft Name, MaxSendSize   [PS] Get-DistributionGroup   | ft Name, *Accept*

  1. 2. [PS] New-MailboxExportRequest -Mailbox mail2k10.johnny -FilePath \\Server\C$\Temp\Mail2k10_johnny_Export.pst -IncludeFolders "行事曆","連絡人" 3.

  http://exchangeserverpro.com/list-users-access-exchange-mailboxes/   [PS] C:\Windows\system32>get-mailbox -OrganizationalUnit System_Accounts | Get-MailboxPermission | Where {$_.user.tostring() -ne "NT AUTHORITY\SELF" -and $_.IsInherited -eq $false} | Select Identity,User,@{Name='Access Rights';Expression={[string]::join(', ', $_.AccessRights)}} | Export-Csv -NoTypeInformation c:\mailboxpermissions.csv

  http://thoughtsofanidlemind.com/2014/01/15/eas-device-partnerships/ http://www.symantec.com/connect/forums/script-remove-stale-exchange-activesync-device-partnerships-mobile-management-implementation [PS] > Get-ActiveSyncDeviceStatistics -Mailbox johnny.yao | ft DeviceFriendlyName,DeviceOS,LastSuccessSync [PS] > Get-ActiveSyncDevice -Mailbox johnny.yao | ft FriendlyName, DeviceModel, DeviceType, DeviceOS [ [PS] > $Mbx = Get-Mailbox -RecipientTypeDetails UserMailbox -ResultSize Unlimited $Mobile = $Mbx | %{Get-ActiveSyncDeviceStatistics -Mailbox $_.Identity} $Mobile | Group-Object -Property DeviceType –NoElement $Mobile | Group-Object -Property DeviceOS –NoElement $Mobile | Group-Object -Property DeviceFriendlyName –NoElement [PS] >Get-CASMailbox -ResultSize Unlimited -Filter {(HasActivesyncDevicePartnership -eq $false)} -OrganizationalUnit Users | ft name [PS] >Get-ActiveSyncDeviceStatistics -Mailbox Johnny.yao | Wher...

    Name BusinessPhone ABC.DEF 1234-5678   1. [PS] C:\>$csvinfo = Import-Csv   extension.csv 2. [PS] C:\>foreach ($line in $csvinfo) {Get-User -Identity "$($line.name)" | ft Name,Phone >>c:\before_ext-1.txt } 3. [PS] C:\>foreach ($line in $csvinfo) {Get-User -Identity "$($line.name)" | Set-User -Phone "$($Line.Busine ssPhone)"} 4. [PS] C:\>foreach ($line in $csvinfo) {Get-User -Identity "$($line.name)" | ft Name,Phone >>c:\after_ext-1.txt } 5.. excel 檢核 =IF(A2=D2,"Y","No")

http://technet.microsoft.com/library/bb738157(EXCHG.80).aspx http://technet.microsoft.com/zh-TW/library/aa998847(v=exchg.80).aspx http://technet.microsoft.com/zh-TW/library/bb430771(v=exchg.80).aspx http://technet.microsoft.com/en-us/library/dd335105(v=exchg.141).aspx [PS] C:\>Get-AddressList -Identity bqat | Set-AddressList -RecipientFilter {(HiddenFromAddressListsEnabled -ne '$True') -and (Alias -ne '$null') -and (((ObjectClass -eq 'user') -and (Office -like 'BQat*'))  -or ((ObjectClass -eq 'group') -a nd (CustomAttribute1 -eq 'BQat'))) } -ForceUpgrade [PS] C:\>Set-AddressList -Identity MSFT -RecipientFilter "(  ((HiddenFromAddressListsEnabled -ne '$True') -and (Alias -like '*')) -and ( ((ObjectClass -eq 'User') -and (company -eq 'MSFT')) -or ((ObjectClass -eq 'Group') -and (CustomAttribute1 -eq 'MSFT' )  ) ) ) "

  http://msundis.wordpress.com/2011/10/28/quick-tip-view-the-database-size-and-mailbox-count-for-mailbox-databases/ Mailbox count for mailbox databases Get-Mailbox -server BQT-MBX01 -ResultSize:Unlimited | Group-Object -Property:Database | Select-Object Name,Count | Sort-Object -Property:Count –Descending   MailboxDatabase sizes Get-MailboxDatabase -Server bqt-mbx01 -Status | select Servername,Name,databasesize

    造成亂碼主要是中文編碼的問題，最快的解決方法就是把 xxx.csv 用Notepad開啟，然後到左上方選項「檔案」選擇「另存新檔」，然後會出現儲存視窗，請確認文字編碼為「UTF-8」後，在另存的檔名後面加上.csv，如原本為contact，加完就變成contact.csv，然後按下儲存就可以了！ http://www.cloudgss.com/cloud/tw/support/faq/35-videgree-import/111-yahoo-mail-csv

    [PS] C:\Windows\system32> Get-Command Exsetup.exe | ForEach-Object {$_.FileVersionInfo} ProductVersion   FileVersion      FileName --------------   -----------      -------- 14.03.0174.001   14.03.0174.001   D:\Exchsrvr\bin\ExSetup.exe

    Reference http://social.technet.microsoft.com/Forums/exchange/en-US/6ec28ddb-63f3-4b6f-9d75-b0b507f9c0d7/how-to-move-database-using-database-portability-in-exchange-2010?forum=exchange2010 http://technet.microsoft.com/en-us/library/dd876926.aspx http://msexchangeguru.com/2013/04/15/e2010-database-portability/ A offline DB that need to recover on new server Check DB state first Copy DB to a new server. Rename old folder, and create a new folder for the Database Create a database for recovery on new server Specific the DB path Mount DB Enable restore on this DB Dismount DB Remove new db & logs Remove .chk file Mount the database After the database is mounted, modify the...

    l 非DAG 資料庫備份，單純E14 一般DB l 原先透過GUI 設定排程正常備份及truncate log l 近來出現備份警告，有完成備份，但無truncate log l 有重設job 及調整備份路徑無效 l 爬文後，改為透過wbadmin (同DAG 設定job 方式) 設定backup job，即可完成正常備份及truncate log Exchange 2010 - Full backups with Windows Backup Not Clearing Transaction Logs http://social.technet.microsoft.com/Forums/windowsserver/en-US/093b7a8b-d4e8-46d3-b8a0-b3546a08bd9a/exchange-2010-full-backups-with-windows-backup-not-clearing-transaction-logs

  Change a UM Enable user to a new dial Plan http://social.technet.microsoft.com/Forums/exchange/en-US/a05d98f8-4f96-447e-8188-4b5e09551d13/change-a-um-enable-user-to-a-new-dial-plan     Enabled UMMailbox Dump sAMAccountName & Phone   test import first echo 'samaccountname,extension' > userlist.csv         ======================================             ==============================