Johnny Yao WorkSpace

  http://www.slipstick.com/outlook/suggested-contacts-and-auto-complete-lists/   http://www.windowsreference.com/ms-office/how-to-enabledisable-autocomplete-in-ms-outlook/   Outlook.exe /CleanAutoCompleteCache

    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://howdouc.blogspot.tw/2010/06/bulk-importcreate-mail-enabled-contacts.html http://msexchangeguru.com/2012/11/16/contacts-in-bulk/   [PS] C:\>$csvinfo = Import-Csv ABC.csv 建立MailContact [PS] C:\>foreach ($line in $csvinfo) {New-MailContact -Name $line.name -ExternalEmailAddress $line.Em ailAddress -LastName $line.LastName -DisplayName $line.DisplayName -Alias $line.Alias -OrganizationalUnit ABC_OU}   更新contact 的phone 資訊  (要從contact 更新，非MailContact) [PS] C:\>foreach ($line in $csvinfo) {Get-Contact -Identity "$($line.DisplayName)" | Set-Contact -Pho ne "$($Line.BusinessPhone)"} 更新中文姓名 (csv 轉存 utf-8) [PS] C:\>foreach ($line in $csvinfo) {Get-Contact -Identity "$($line.DisplayName)" | Set-Contact -Las tName "$($Line.LastName)"}

  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