Query on Room mailboxes

Question

Hi All

i using exchange 2016 hybrid environment. i have room mailboxes created in onprem as remote mailboxes. i want to know in last one month how many bookings have been made and who has booked the room and who are the attendees. is this possible to fetch this information.

Answer 1

You can use either the Graph API or EWS to generate such report. Here's example on how to do it via Graph: https://practical365.com/report-room-mailbox-statistics/

And this one for EWS: https://letsexchange.blogspot.com/2017/05/exchange-meeting-room-statistics.html?m=0

Answer 2

I have connected to exchange online and use the below script, i am getting below error please guide me

https://github.com/NunoFilipeMota/PublicScripts/blob/main/GetMeetingRoomStats_GraphAPI.ps1

PS C:\temp> .\GetMeetingRoomStats_GraphAPI.ps1 -RoomListSMTP "******@contoso.com" -From "02/01/2023" -To "03/01/2023" 


At C:\temp\GetMeetingRoomStats_GraphAPI.ps1:208 char:17
+             Sign up
+                 ~
The ampersand (&) character is not allowed. The & operator is reserved for future use; wrap an ampersand in double quotation marks ("&") to pass it as part of a string.
At C:\temp\GetMeetingRoomStats_GraphAPI.ps1:213 char:209
+ ... k Button--medium Button d-lg-none color-fg-inherit p-1">    <span cla ...
+                                                                 ~
The '<' operator is reserved for future use.
At C:\temp\GetMeetingRoomStats_GraphAPI.ps1:431 char:13
+       CI/CD &amp; Automation
+             ~
The ampersand (&) character is not allowed. The & operator is reserved for future use; wrap an ampersand in double quotation marks ("&") to pass it as part of a string.
At C:\temp\GetMeetingRoomStats_GraphAPI.ps1:1355 char:96
+ ... ="" data-disable-with="" data-dropdown-tracking="{&quot;type&quot;:&q ...
+                                                                 ~
The ampersand (&) character is not allowed. The & operator is reserved for future use; wrap an ampersand in double quotation marks ("&") to pass it as part of a string.
At C:\temp\GetMeetingRoomStats_GraphAPI.ps1:1355 char:103
+ ... a-disable-with="" data-dropdown-tracking="{&quot;type&quot;:&quot;blo ...
+                                                                 ~
The ampersand (&) character is not allowed. The & operator is reserved for future use; wrap an ampersand in double quotation marks ("&") to pass it as part of a string.
At C:\temp\GetMeetingRoomStats_GraphAPI.ps1:1355 char:146
+ ... &quot;type&quot;:&quot;blob_edit_dropdown.more_options_click&quot;,&q ...
+                                                                 ~
The ampersand (&) character is not allowed. The & operator is reserved for future use; wrap an ampersand in double quotation marks ("&") to pass it as part of a string.
At C:\temp\GetMeetingRoomStats_GraphAPI.ps1:1355 char:153
+ ... type&quot;:&quot;blob_edit_dropdown.more_options_click&quot;,&quot;co ...
+                                                                  ~
Missing expression after unary operator ','.
At C:\temp\GetMeetingRoomStats_GraphAPI.ps1:1355 char:153
+ ... ype&quot;:&quot;blob_edit_dropdown.more_options_click&quot;,&quot;con ...
+                                                                 ~
Unexpected token '&' in expression or statement.
At C:\temp\GetMeetingRoomStats_GraphAPI.ps1:1355 char:166
+ ... ot;blob_edit_dropdown.more_options_click&quot;,&quot;context&quot;:{& ...
+                                                                 ~
The ampersand (&) character is not allowed. The & operator is reserved for future use; wrap an ampersand in double quotation marks ("&") to pass it as part of a string.
At C:\temp\GetMeetingRoomStats_GraphAPI.ps1:1355 char:193
+ ... options_click&quot;,&quot;context&quot;:{&quot;repository_id&quot;:34 ...
+                                                                 ~
The ampersand (&) character is not allowed. The & operator is reserved for future use; wrap an ampersand in double quotation marks ("&") to pass it as part of a string.
Not all parse errors were reported.  Correct the reported errors and try again.
    + CategoryInfo          : ParserError: (:) [], ParseException
    + FullyQualifiedErrorId : AmpersandNotAllowed