Exchange Online Meeting Room Statistics - Graph API

This script uses Graph API to connect to one or more meeting rooms and gather statistics regarding their usage between specific dates. Although the script is targeted at meeting rooms, it will work with any mailbox default calendar in Exchange Online.

1,231 times
Add to favorites
Office 365
E-mail Twitter Digg Facebook
  • Proper Report
    2 Posts | Last post March 10, 2020
    • I ran the old one, and after a while of updating installed tools, and adjusting the Powershell script, i got part of it until the Bing 2 error. Now its to install an app registration, etc, etc... 
      How about Microsoft takes the time to create a built-in custom report into the interface (like the 8 million of us have requested) instead of a having to hack-it-up and rebuild Rome to get the results. 
      Most of us dont have the time....Please
    • Tell me about it... It took me a while to get used to Graph API, but once you get familiar with it, you can simply reuse most of the code for other Graph API scripts, and it is not as bad! Still prefer the "old" remote PowerShell and PowerShell cmdlets though...   :(
  • All meetings in totalPM
    2 Posts | Last post March 10, 2020
    • Hi, running the script in Norway with 24h clock, all meetings are registred under totalPM. Is there any easy way to fix this?
    • Hi. Please get the dateTime of any meeting, and run the following: Get-Date $meeting.start.dateTime -UFormat %p
      What does it return? Please let me see what you run and the output. Thanks.
  • How will i do app registration
    2 Posts | Last post March 06, 2020
    • Question 1 --> How will i do below steps.
      The app registration will need the following API permissions to Graph API: 'User.Read.All' and 'Calendars.Read', both of type 'Application';
      Question 2--> Is it possible to import all rooms in CSV and run script against those rooms
    • Hi Manoj,
      1. Go to the Azure management portal (, then go to "App registrations", and click on "New registration". From there, give it a name, create a secret, and in "API permissions", give the permissions I mention in the script for "Microsoft Graph".
      2. Not at the moment as I'd need to update the script to work with CSV files... Maybe in the next version!