Exporting the Prompt Contacts, OWA Auto-complete Cache and Recipient Cache in Alternate 2013 with EWS and PowerShell

Exporting the Prompt Contacts, OWA Auto-complete Cache and Recipient Cache in Alternate 2013 with EWS and PowerShell The next script creates a CSV export of Robotically generated contacts which have been saved in any of the three following auto contact places

Prompt Contacts Folder which is Outlook characteristic that mechanically creates a Contact for every tackle you ship an e-mail to – http://workplace.microsoft.com/en-au/outlook-help/automatically-add-contacts-for-everyone-that-you-send-an-email-message-HA101874367.aspx

OWA Autocomplete Cache – That is OWA model of the NickName cache, its saved in a UserConfiguration object within the Root of the Mailbox. The Addresses are saved inside an XML Streaming Property.

Recipeints Cache Folder – This can be a new Alternate 2013 folder which is a hidden sub folder of the Contacts folder with a mailbox and it is goal is not actually documented in the mean time, however incorporates just like the AutoComplete cache,  Addresses for Despatched Emails.

So this script simply create a CSV file with the Supply, DisplayName and E-mail-address of any entries from these three places.

I’ve put a download of this script right here

The code appears like

  1. ## Get the Mailbox to Entry from the 1st commandline argument  
  2.   
  3. $MailboxName = $args[0]  
  4.   
  5. ## Load Managed API dll    
  6. Add-Kind -Path “C:Program FilesMicrosoftExchangeWeb Services2.0Microsoft.Exchange.WebServices.dll”    
  7.     
  8. ## Set Alternate Model    
  9. $ExchangeVersion = [Microsoft.Exchange.WebServices.Data.ExchangeVersion]::Alternate2013  
  10.     
  11. ## Create Alternate Service Object    
  12. $service = New-Object Microsoft.Alternate.WebServices.Knowledge.ExchangeService($ExchangeVersion)    
  13.     
  14. ## Set Credentials to use two choices are availible Option1 to use explict credentials or Possibility 2 use the Default (logged On) credentials    
  15.     
  16. #Credentials Possibility 1 utilizing UPN for the home windows Account    
  17. $psCred = Get-Credential    
  18. $creds = New-Object System.Internet.NetworkCredential($psCred.UserName.ToString(),$psCred.GetNetworkCredential().password.ToString())    
  19. $service.Credentials = $creds        
  20.     
  21. #Credentials Possibility 2    
  22. #service.UseDefaultCredentials = $true    
  23.     
  24. ## Select to ignore any SSL Warning points triggered by Self Signed Certificates    
  25.     
  26. ## Code From http://poshcode.org/624  
  27. ## Create a compilation surroundings  
  28. $Supplier=New-Object Microsoft.CSharp.CSharpCodeProvider  
  29. $Compiler=$Supplier.CreateCompiler()  
  30. $Params=New-Object System.CodeDom.Compiler.CompilerParameters  
  31. $Params.GenerateExecutable=$False  
  32. $Params.GenerateInMemory=$True  
  33. $Params.IncludeDebugInformation=$False  
  34. $Params.ReferencedAssemblies.Add(“System.DLL”) | Out-Null  
  35.   
  36. $TASource[email protected] 
  37.   namespace Native.ToolkitExtensions.Internet.CertificatePolicy{ 
  38.     public class TrustAll : System.Internet.ICertificatePolicy { 
  39.       public TrustAll() {  
  40.       } 
  41.       public bool CheckValidationResult(System.Internet.ServicePoint sp, 
  42.         System.Safety.Cryptography.X509Certificates.X509Certificates cert,  
  43.         System.Internet.WebRequest req, int downside) { 
  44.         return true; 
  45.       } 
  46.     } 
  47.   } 
  48. @   
  49. $TAResults=$Supplier.CompileAssemblyFromSource($Params,$TASource)  
  50. $TAAssembly=$TAResults.CompiledAssembly  
  51.   
  52. ## We now create an occasion of the TrustAll and connect it to the ServicePointManager  
  53. $TrustAll=$TAAssembly.CreateInstance(“Local.ToolkitExtensions.Net.CertificatePolicy.TrustAll”)  
  54. [System.Net.ServicePointManager]::CertificatePolicy=$TrustAll  
  55.   
  56. ## finish code from http://poshcode.org/624  
  57.     
  58. ## Set the URL of the CAS (Shopper Entry Server) to use two choices are availbe to use Autodiscover to discover the CAS URL or Hardcode the CAS to use    
  59.     
  60. #CAS URL Possibility 1 Autodiscover    
  61. $service.AutodiscoverUrl($MailboxName,{$true})    
  62. “Using CAS Server : “ + $Service.url     
  63.      
  64. #CAS URL Possibility 2 Hardcoded    
  65.     
  66. #$uri=[system.URI] “https://casservername/ews/exchange.asmx”    
  67. #$service.Url = $uri      
  68.     
  69. ## Non-compulsory part for Alternate Impersonation    
  70.     
  71. #$service.ImpersonatedUserId = new-object Microsoft.Alternate.WebServices.Knowledge.ImpersonatedUserId([Microsoft.Exchange.WebServices.Data.ConnectingIdType]::SmtpAddress, $MailboxName)   
  72. $ExportCollection = @()  
  73. Write-Host “Process Recipient Cache”  
  74. $folderid= new-object Microsoft.Alternate.WebServices.Knowledge.FolderId([Microsoft.Exchange.WebServices.Data.WellKnownFolderName]::RecipientCache,$MailboxName)     
  75. $RecipientCache = [Microsoft.Exchange.WebServices.Data.Folder]::Bind($service,$folderid)  
  76.   
  77. $psPropset= new-object Microsoft.Alternate.WebServices.Knowledge.PropertySet([Microsoft.Exchange.WebServices.Data.BasePropertySet]::FirstClassProperties)    
  78. #Outline ItemView to retrive simply 1000 Gadgets      
  79. $ivItemView =  New-Object Microsoft.Alternate.WebServices.Knowledge.ItemView(1000)      
  80. $fiItems = $null      
  81. do{      
  82.     $fiItems = $service.FindItems($RecipientCache.Id,$ivItemView)      
  83.     [Void]$service.LoadPropertiesForItems($fiItems,$psPropset)    
  84.     foreach($Merchandise in $fiItems.Gadgets){       
  85.         if($Merchandise -is [Microsoft.Exchange.WebServices.Data.Contact]){  
  86.             $expObj = “” | choose Supply,DisplayName,Email1DisplayName,Email1Type,Email1EmailAddress  
  87.             $expObj.Supply = “RecipientCache”  
  88.             $expObj.DisplayName = $Merchandise.DisplayName  
  89.             if($Merchandise.EmailAddresses.Accommodates([Microsoft.Exchange.WebServices.Data.EmailAddressKey]::EmailAddress1)){                  
  90.                 $expObj.Email1DisplayName = $Merchandise.EmailAddresses[[Microsoft.Exchange.WebServices.Data.EmailAddressKey]::EmailAddress1].Title  
  91.                 $expObj.Email1Type = $Merchandise.EmailAddresses[[Microsoft.Exchange.WebServices.Data.EmailAddressKey]::EmailAddress1].RoutingType  
  92.                 $expObj.Email1EmailAddress = $Merchandise.EmailAddresses[[Microsoft.Exchange.WebServices.Data.EmailAddressKey]::EmailAddress1].Handle  
  93.             }  
  94.             $ExportCollection += $expObj  
  95.         }  
  96.     }      
  97.     $ivItemView.Offset += $fiItems.Gadgets.Depend      
  98. }whereas($fiItems.MoreAvailable -eq $true)   
  99.   
  100. Write-Host “Process Suggested Contacts”  
  101. $folderid = new-object Microsoft.Alternate.WebServices.Knowledge.FolderId([Microsoft.Exchange.WebServices.Data.WellKnownFolderName]::MsgFolderRoot,$MailboxName)   
  102. $fvFolderView = new-object Microsoft.Alternate.WebServices.Knowledge.FolderView(1)  
  103. $SfSearchFilter = new-object Microsoft.Alternate.WebServices.Knowledge.SearchFilter+IsEqualTo([Microsoft.Exchange.WebServices.Data.FolderSchema]::DisplayName,“Suggested Contacts”)  
  104. $findFolderResults = $service.FindFolders($folderid,$SfSearchFilter,$fvFolderView)  
  105.   
  106. if($findFolderResults.Folders.Depend -gt 0){  
  107.     $psPropset= new-object Microsoft.Alternate.WebServices.Knowledge.PropertySet([Microsoft.Exchange.WebServices.Data.BasePropertySet]::FirstClassProperties)    
  108.     #Outline ItemView to retrive simply 1000 Gadgets      
  109.     $ivItemView =  New-Object Microsoft.Alternate.WebServices.Knowledge.ItemView(1000)      
  110.     $fiItems = $null      
  111.     do{      
  112.         $fiItems = $service.FindItems($findFolderResults.Folders[0].Id,$ivItemView)      
  113.         [Void]$service.LoadPropertiesForItems($fiItems,$psPropset)    
  114.         foreach($Merchandise in $fiItems.Gadgets){       
  115.             if($Merchandise -is [Microsoft.Exchange.WebServices.Data.Contact]){  
  116.                 $expObj = “” | choose Supply,DisplayName,Email1DisplayName,Email1Type,Email1EmailAddress  
  117.                 $expObj.Supply = “Suggested Contacts”  
  118.                 $expObj.DisplayName = $Merchandise.DisplayName  
  119.                 if($Merchandise.EmailAddresses.Accommodates([Microsoft.Exchange.WebServices.Data.EmailAddressKey]::EmailAddress1)){                  
  120.                     $expObj.Email1DisplayName = $Merchandise.EmailAddresses[[Microsoft.Exchange.WebServices.Data.EmailAddressKey]::EmailAddress1].Title  
  121.                     $expObj.Email1Type = $Merchandise.EmailAddresses[[Microsoft.Exchange.WebServices.Data.EmailAddressKey]::EmailAddress1].RoutingType  
  122.                     $expObj.Email1EmailAddress = $Merchandise.EmailAddresses[[Microsoft.Exchange.WebServices.Data.EmailAddressKey]::EmailAddress1].Handle  
  123.                 }  
  124.                 $ExportCollection += $expObj  
  125.             }  
  126.         }      
  127.         $ivItemView.Offset += $fiItems.Gadgets.Depend      
  128.     }whereas($fiItems.MoreAvailable -eq $true)   
  129. }  
  130. Write-Host “Process OWA AutocompleteCache”  
  131. #$service.ImpersonatedUserId = new-object Microsoft.Alternate.WebServices.Knowledge.ImpersonatedUserId([Microsoft.Exchange.WebServices.Data.ConnectingIdType]::SmtpAddress, $MailboxName)$folderid = new-object Microsoft.Alternate.WebServices.Knowledge.FolderId([Microsoft.Exchange.WebServices.Data.WellKnownFolderName]::Root,$MailboxName)   
  132. $folderid= new-object Microsoft.Alternate.WebServices.Knowledge.FolderId([Microsoft.Exchange.WebServices.Data.WellKnownFolderName]::Root,$MailboxName)       
  133. #Specify the Calendar folder the place the FAI Merchandise is    
  134. $UsrConfig = [Microsoft.Exchange.WebServices.Data.UserConfiguration]::Bind($service“OWA.AutocompleteCache”$folderid, [Microsoft.Exchange.WebServices.Data.UserConfigurationProperties]::All)    
  135. #Get the XML in String Format    
  136. $acXML = [System.Text.Encoding]::UTF8.GetString($UsrConfig.XmlData)    
  137. #Deal with the first character being a Byte Order Mark    
  138. $boMark = $acXML.SubString(0,1)    
  139. #Parse the XML    
  140. [XML]$acXML = $acXML.SubString(1)    
  141. foreach($AcEnt in $acXML.AutoCompleteCache.Entry) choose Supply,DisplayName,Email1DisplayName,Email1Type,Email1EmailAddress  
  142.     $expObj.Supply = “OWA AutocompleteCache”  
  143.     $expObj.DisplayName = $AcEnt.displayName  
  144.     $expObj.Email1DisplayName= $AcEnt.displayName  
  145.     $expObj.Email1Type= “SMTP”  
  146.     $expObj.Email1EmailAddress= $AcEnt.smtpAddr  
  147.     $ExportCollection +=$expObj   
  148.   
  149. $fnFileName = “c:temp” + $MailboxName + “AC-CacheExport.csv 
  150. $ExportCollection | Export-Csv -NoTypeInformation -Path $fnFileName 
  151. Exported to ” + $fnFileName  

Leave a Reply