Group Booking Attendance List

%3CLINGO-SUB%20id%3D%22lingo-sub-2129510%22%20slang%3D%22en-US%22%3EGroup%20Booking%20Attendance%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2129510%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20of%20a%20way%20to%20print%20a%20list%20of%20registered%20customers%20for%20a%20group%20event%3F%26nbsp%3B%20I%20have%20look%206%20ways%20from%20Sunday%20and%20haven't%20been%20able%20to%20find%20a%20way.%26nbsp%3B%20If%20there%20isn't%20currently%20an%20option%20to%20do%20this%2C%20how%20do%20I%20go%20about%20suggesting%20it%20to%20Microsoft%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EChris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2129510%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebooking%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGroup%20Event%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2142262%22%20slang%3D%22en-US%22%3ERe%3A%20Group%20Booking%20Attendance%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2142262%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F965255%22%20target%3D%22_blank%22%3E%40ChrisStubbs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Chris%2C%26nbsp%3B%3CBR%20%2F%3EI%20have%20been%20struggling%20as%20well%20and%20I%20did%20find%20a%20way%2C%20but%20I%20must%20say%20it%20is%20not%20the%20easiest%20solution.%20It%20is%20a%20pretty%20technical%20solution.%3C%2FP%3E%3COL%3E%3CLI%3EYou%20have%20to%20gain%20full%20access%20to%20the%20Bookings-mailbox%20(not%20the%20employee)%2C%20this%20can%20be%20done%20via%26nbsp%3B%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EPowershell%3A%20Add-MailboxPermission%20-Identity%20target%40mailbox.com%26nbsp%3B%20-User%20user%40mailbox.com%20-AccessRights%20FullAccess%20-InheritanceType%20All%E2%80%8B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSPAN%3EAfter%20the%20mailbox%20appears%20in%20Outlook%20(local%2C%20not%20owa)%2C%20download%20the%20application%20MFCMapi%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fstephenegriffin%2Fmfcmapi%2Freleases%2Ftag%2F19.2.19207.938%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Emfcmapi%3C%2FA%3E%26nbsp%3B(be%20extremely%20careful%2C%20you%20can%20breakdown%20your%20mailbox)%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3Eopen%20MFCMapi%2C%20go%20to%20Session%2C%20Logon%20and%20choose%20your%20Outlook%20profile%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3Eright-click%20and%20open%20the%20datastore%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3Eexpand%20folder%20and%20in%20the%20top%20of%20the%20archive%20right-click%20on%20calendar%2C%20open%20contentstable.%20you%20will%20see%20all%20appointments.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3Eselect%20all%20appointments%20and%20%22export%20message%22%20(messages%2C%20this%20is%20a%20selection)%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3Esave%20all%20appointments%20as%20.XML%20file%20in%20a%20desired%20folder.%20you%20should%20have%20as%20many%20XML-files%20as%20there%20are%20appointments.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3E%3CSPAN%3Euse%20a%20Powershell-script%20to%20extract%20the%20desired%20info%20from%20all%20XML-files%20to%20a%20CSV%20(or%20whatever)%2C%20you%20can%20use%20this%20example%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-powershell%22%3E%3CCODE%3E%24files%20%3D%20Get-ChildItem%20%22C%3A%5Ctemp%22%20-Filter%20*.xml%0Acd%20c%3A%5Ctemp%5C%0A%0A%0Aforeach%20(%24file%20in%20%24files)%7B%0A%20%20%5Bxml%5D%24Types%20%3D%20Get-Content%20-Path%20%24file%0A%20%20%24ans%20%3D%20Select-Xml%20-Xml%20%24Types%20-XPath%20%22%2F%2Fproperties%2Fproperty%22%20%7C%20Select-Object%20-ExpandProperty%20node%20%7C%20where-object%20%7B%24_.tag%20-eq%20'0x82750102'%7D%20%7C%20Select-Object%20-ExpandProperty%20AltValue%20%20%23%7C%20Format-list%20-%20%20%20%23-GroupBy%20'%2C'%20%7C%20out-file%20-FilePath%20c%3A%5Ctemp%5Ctest.txt%20-Append%0A%20%20%24ans.OuterXml%20%7C%20out-file%20-FilePath%20c%3A%5Ctemp%5Ctest.txt%20-Append%0A%20%20%7D%20%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3Ethe%20output-file%20you%20can%20import%20in%20Excel%2Fpowerbi%20and%20clean%20the%20data%20using%20the%20import-query.%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3EIt%20is%20not%20easy%2C%20but%20once%20you%20have%20set%20everything%20up%2C%20it%20takes%20less%20time%20to%20execute.%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3EKind%20regards%2C%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3EJordy%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello everyone,

 

Does anyone know of a way to print a list of registered customers for a group event?  I have look 6 ways from Sunday and haven't been able to find a way.  If there isn't currently an option to do this, how do I go about suggesting it to Microsoft?

 

Thanks

Chris

2 Replies

@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