Exchange Meeting Room Statistics

This script uses Exchange Web Services to connect to one or more meeting rooms and gather statistics regarding their usage between to specific dates.

 
 
 
 
 
4.5 Star
(6)
7,213 times
Add to favorites
Exchange
12/15/2017
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • Suggestion on Parameters
    1 Posts | Last post July 19, 2019
    • Not a question, more a suggestion, if you replace the parameters to be:
      	[Parameter(Position = 1, Mandatory = $False)]
      	[DateTime] $From = (Get-Date -Day 1 -Hour 0 -Minute -0 -Second 0).AddMonths(-1),
      	
      	[Parameter(Position = 2, Mandatory = $False)]
      	[DateTime] $To = (Get-Date -Day 1 -Hour 0 -Minute -0 -Second 0),
      
      It will default to giving you the last months reports for the rooms selected. Handy if you are automating reports for the business.
      
      Awesome script all in all, thank you for taking the time to write it, this has opened up alot of reporting opportunities. 
      
      
  • AutoDiscover Blocked...
    2 Posts | Last post July 02, 2019
    • I to am getting the auto discover issue. I have verified auto discover is working.
      
      xception calling "AutodiscoverUrl" with "1" argument(s): "Autodiscover blocked a potentially insecure redirection to https://autodiscover.xx.xxx.com/autodiscover/autodiscover.xml. To allow Autodiscover to follow the redirection, use the AutodiscoverUrl(string, 
      AutodiscoverRedirectionUrlValidationCallback) overload."
      At C:\Users\u93552.UNCH\Desktop\Scripts\Get-MeetingRoomStats.ps1:105 char:3
      +         $service.AutodiscoverUrl($Mailbox)
      
      Any help appreciated...
    • Add switch -ExchangeOnline
  • How to get the details of all the Meeting Rooms...
    1 Posts | Last post June 27, 2019
    • Hi , Thanks for your script , is there a way to get date of all the meeting rooms ? Without mentioning one at a time  or to call txt /csv file with room smtp address or details. 
      
      Thanks
      
  • 1000 Result size limit
    1 Posts | Last post May 15, 2019
    • I seemed to have hit the result size limit of 1000 defined in the "$CalendarView" object. And it would not allow me to increase that number any higher, instead the error suggest me use "paging". Any suggestion on how to get pass this? Thanks!
      
      Following is the error message:
      
      VERBOSE: Unable to retrieve data from user@domain.com calendar. Please check permissions: Exception calling "FindAppointments" with "2" argument(s): "You have exceeded the maximum number of objects that can be
      returned for the find operation. Use paging to reduce the result size and try your request again.". Skipping user@domain.com.
  • Exporting to ics?
    1 Posts | Last post May 14, 2019
    • Do you think this script could be modified to export O365 calendars to ICS files?  
      
      I think there's a way of granting access to the anonymous user and then getting a link out of OWA's Calendar (Options > Shared Calendars > Calendar Publishing) and downloading the file from there; but it doesn't seem very straight-forward.
  • RoomName
    1 Posts | Last post April 20, 2019
    • Hi Nuno,
      the script is very usefull thank you.
      
      But the RoomName does not show up.
      I am using Exchange Online O365.
      
      Do you have any idea why?
      
      RoomName     :
      From         : 01.03.2019 00:00:00
      To           : 31.03.2019 00:00:00
      RoomEmail    : Room1@xxxxxxxx.onmicrosoft.com
      ….
      
      Regards,
      Joe
      
  • Unable to connect
    3 Posts | Last post April 11, 2019
    • Hi Nuno,
      
      Getting this error with the following request : .\Get-MeetingRoomStats.ps1 -RoomListSMTP "room@domains.com" -ExchangeOnline -From "04/01/2019" -To "04/02/2019" -Verbose
      
      any idea ?
      
      VERBOSE: Unable to connect to room@domains.com Please check permissions:
      Exception calling "Bind" with "2" argument(s): "The specified folder could not be found in the store.". Skipping room@domains.com.
    • rights was missing on the calendar :)
    • Glad you figured it out!    :)
  • Exchange2010
    1 Posts | Last post March 04, 2019
    • Anyone,
      
      Is still get error message when i try it under Exchange 2010, any clue? Thx!!
      VERBOSE: Loading EWS Managed API
      VERBOSE: Creating Exchange Service Object using AutoDiscover
      VERBOSE: Binding to the xxxx@yyyy.com Calendar folder.
      VERBOSE: Unable to retrieve data from MBX-MRG64F@fluxys.com calendar. Please check permissions: Cannot convert argument
       "0", with value: "Microsoft.Exchange.WebServices.Data.Appointment Microsoft.Exchange.WebServices.Data.Appointment
      Microsoft.Exchange.WebServices.Data.Appointment 
      Microsoft.Exchange.WebServices.Data.Appointment 
      Microsoft.Exchange.WebServices.Data.Appointment 
       Microsoft.Exchange.WebServices.Data.Appointment", for
       for
      "LoadPropertiesForItems" to type "System.Collections.Generic.IEnumerable`1[Microsoft.Exchange.WebServices.Data.Item]":
      "Cannot convert the
      "Microsoft.Exchange.WebServices.Data.FindItemsResults`1[Microsoft.Exchange.WebServices.Data.Appointment]" value of type
       "Microsoft.Exchange.WebServices.Data.FindItemsResults`1[[Microsoft.Exchange.WebServices.Data.Appointment,
      Microsoft.Exchange.WebServices, Version=15.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]" to type
      "System.Collections.Generic.IEnumerable`1[Microsoft.Exchange.WebServices.Data.Item]".". Skipping xxxx@yyyy.com.
  • Report of Hundreds of Rooms per Location
    1 Posts | Last post February 20, 2019
    • Hi Nuno,
      
      I need help in obtaining a report from specific location such as Tampa and Dallas. Good thing is all rooms in Tampa starts with TP and Dallas rooms starts with DA. Can you help me with the script to obtain reports from those location?
  • AM/PM Specification
    1 Posts | Last post February 19, 2019
    • Would it be possible to change the AM PM Specification to a specific set time as the reporting could be used for rooms from east coast or west coast. 
      
      Cheers.
11 - 20 of 41 Items