Feb 12 2021 11:20 AM
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
Feb 17 2021 01:17 AM
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.
Powershell: Add-MailboxPermission -Identity target@mailbox.com -User user@mailbox.com -AccessRights FullAccess -InheritanceType All
$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
Feb 18 2021 01:10 PM