title: Retrieve public folder calendar appointments with Exchange Powershell
body: <p>I'm trying to retrieve all appointments existing on a calendar in the organization's public folders, for reporting purposes. </p>
  
  <p>Exchange 2010's Powershell cmdlet <code>Get-PublicFolderItemStatistics</code> does return some of the information I need, but it seems like the returned objects are missing some of the properties <a href="http://msdn.microsoft.com/en-us/library/bb176631(v=office.12).aspx" rel="nofollow noreferrer">that should exist on the Appointment object</a>, even though I do see their values on the appointment in Outlook (also 2010).</p>
  
  <p>Specifically, I need the Start and End date properties, which are coming back blank.</p>
  
  <p>An example:</p>
  
  <pre><code>Get-PublicFolderItemStatistics -identity "\30 Day" | Sort-Object CreationTime | Format-List
  </code></pre>
  
  <p>Returns:</p>
  
  <pre><code>ServerName           : EXCHANGE1
  DatabaseName         : Public Folder Database 167851469
  Subject              : Test 30
  PublicFolderName     : \30 Day
  LastModificationTime : 1/19/2015 3:05:05 PM
  CreationTime         : 1/19/2015 3:05:05 PM
  HasAttachments       : False
  ItemType             : IPM.Appointment
  MessageSize          : 5.47 KB (5,601 bytes)
  Identity             : (removed)
  MapiIdentity         : (removed)
  OriginatingServer    : exchange1.mydomain.local
  IsValid              : True
  ObjectState          : Changed
  </code></pre>
  
  <p>And: </p>
  
  <pre><code>Get-PublicFolderItemStatistics -identity "\30 Day" | Sort-Object CreationTime | Format-List Subject,CreationTime,Start,End
  </code></pre>
  
  <p>Returns:</p>
  
  <pre><code>Subject      : Test 30
  CreationTime : 1/19/2015 3:05:05 PM
  Start        : 
  End          : 
  </code></pre>
  
  <p>However the appointment in Outlook shows the Start and End times correctly:</p>
  
  <p><img src="https://i.stack.imgur.com/xYtW0.png" alt="Appointment in Outlook"></p>
  
  <p>Is there a way to retrieve this information from the server side? I was hoping to avoid Outlook interop if possible.</p>