Group Booking Attendance List

ChrisStubbs 

Hi Chris, 
I have been struggling as well and I did find a way, but I must say it is not the easiest solution. It is a pretty technical solution.

1. You have to gain full access to the Bookings-mailbox (not the employee), this can be done via 

Powershell: Add-MailboxPermission -Identity target@mailbox.com  -User user@mailbox.com -AccessRights FullAccess -InheritanceType All​

• After the mailbox appears in Outlook (local, not owa), download the application MFCMapi: mfcmapi (be extremely careful, you can breakdown your mailbox)
• open MFCMapi, go to Session, Logon and choose your Outlook profile
• right-click and open the datastore
• expand folder and in the top of the archive right-click on calendar, open contentstable. you will see all appointments.
• select all appointments and "export message" (messages, this is a selection)
• save all appointments as .XML file in a desired folder. you should have as many XML-files as there are appointments.
• use a Powershell-script to extract the desired info from all XML-files to a CSV (or whatever), you can use this example:

$files = Get-ChildItem "C:\temp" -Filter *.xml
cd c:\temp\


foreach ($file in $files){
  [xml]$Types = Get-Content -Path $file
  $ans = Select-Xml -Xml $Types -XPath "//properties/property" | Select-Object -ExpandProperty node | where-object {$_.tag -eq '0x82750102'} | Select-Object -ExpandProperty AltValue  #| Format-list -   #-GroupBy ',' | out-file -FilePath c:\temp\test.txt -Append
  $ans.OuterXml | out-file -FilePath c:\temp\test.txt -Append
  } 

the output-file you can import in Excel/powerbi and clean the data using the import-query.

It is not easy, but once you have set everything up, it takes less time to execute.

Kind regards,

Jordy