Meeting Room usage analysis - How to export data for further analysis

%3CLINGO-SUB%20id%3D%22lingo-sub-6470%22%20slang%3D%22en-US%22%3EMeeting%20Room%20usage%20analysis%20-%20How%20to%20export%20data%20for%20further%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-6470%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20currently%20trying%20to%20figure%20out%20how%20to%20analyse%20our%20meeting%20room%20usage.%26nbsp%3B%3C%2FP%3E%3CP%3EWe're%20using%20Exchange%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECase%3A%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20around%2075%20meeting%20rooms.%20Our%20Facility%20services%20would%20really%20appreciate%20if%20we%20could%20give%20them%20some%20sort%20of%20data%20on%20how%20often%20the%20rooms%20are%20used%20(frequency)%2C%20how%20many%20are%20using%20them%20etc.%20Their%20needs%20are%20in%20the%20context%20of%20%22how%20should%20we%20shape%20the%20meeting%20rooms%20in%20the%20future%2C%20should%20we%20build%20more%20in%20one%20location%2C%20and%20close%20down%20some%20in%20another%20location%20and%20so%20on%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20tried%20powershell%20using%20comandlets%20%22Get-CalendarDiagnosticLog%22%20and%20%22Get-CalendarDiagnosticAnalysis%22%2C%20but%20no%20luck%20parsing%20the%20huge%20amounts%20of%20data%20into%20something%20that%20makes%20sense.%20For%20instance%2C%20the%20log-date%20is%20captures%2C%20but%20from%20what%20I%20can%20see%2C%20not%20the%20date%2Ftime%20of%20the%20specific%20room%20and%20attendees.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%20on%20this%20matter%20would%20be%20greatly%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETorbjoern%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-6470%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExchange%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8226%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Meeting%20Room%20usage%20analysis%20-%20How%20to%20export%20data%20for%20further%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8226%22%20slang%3D%22en-US%22%3EAnd%20the%20link%3A%20%3CA%20href%3D%22https%3A%2F%2Foffice365.uservoice.com%2Fforums%2F273493-office-365-admin%2Fsuggestions%2F15876075-meeting-room-usage-statistics-and-reports%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Foffice365.uservoice.com%2Fforums%2F273493-office-365-admin%2Fsuggestions%2F15876075-meeting-room-usage-statistics-and-reports%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8225%22%20slang%3D%22en-US%22%3ERE%3A%20Meeting%20Room%20usage%20analysis%20-%20How%20to%20export%20data%20for%20further%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8225%22%20slang%3D%22en-US%22%3EThanks%20Klaus!%20We%20did%20some%20searches%20where%20the%20first%20article%20came%20up.%20My%20colleague%20tried%20the%20first%20one%20and%20said%20something%20about%20why%20this%20didn't%20work%20in%20our%20org%2C%20but%20we'll%20have%20another%20look%20at%20it%20for%20sure.%20I%20haven't%20seen%20the%20second%20one%20before%2C%20thanks%20a%20lot.%20I've%20just%20submitted%20this%20in%20uservoice.%20All%20things%20considered%2C%20MS%20is%20doing%20a%20pretty%20good%20job%20at%20the%20moment%20presenting%20usage%20reports%20in%20the%20new%20portal%2C%20although%20not%20as%20granular%20or%20detailed%20as%20we'd%20like%2C%20it's%20a%20good%20start%20and%20I'm%20sure%20they%20would%20appreciate%20our%20ideas%20as%20well.%20Please%20vote%20if%20you%20think%20believe%20that%20this%20is%20somewhat%20useful%20%3Bo)%20Link%20will%20be%20provided%20shortly.%20Seems%20like%20the%20uservoice-site%20is%20having%20issues%20at%20the%20moment.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8214%22%20slang%3D%22en-US%22%3ERe%3A%20Meeting%20Room%20usage%20analysis%20-%20How%20to%20export%20data%20for%20further%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8214%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20think%20you%20must%20do%20it%20with%20EWS%20for%20instance%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fwww.msexchange.org%2Farticles-tutorials%2Fexchange-server-2013%2Fmanagement-administration%2Fexchange-meeting-room-statistics.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.msexchange.org%2Farticles-tutorials%2Fexchange-server-2013%2Fmanagement-administration%2Fexchange-meeting-room-statistics.html%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fgsexdev.blogspot.de%2F2009%2F11%2Fbasic-powershell-script-to-show.html%23!%2F2009%2F11%2Fbasic-powershell-script-to-show.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fgsexdev.blogspot.de%2F2009%2F11%2Fbasic-powershell-script-to-show.html%23!%2F2009%2F11%2Fbasic-powershell-script-to-show.html%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20helps%3CBR%20%2F%3EKlaus%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-8103%22%20slang%3D%22en-US%22%3ERe%3A%20Meeting%20Room%20usage%20analysis%20-%20How%20to%20export%20data%20for%20further%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-8103%22%20slang%3D%22en-US%22%3EHi%20again!%3CBR%20%2F%3E%3CBR%20%2F%3ELooks%20like%20this%20question%20will%20go%20unanswered.%20Perhaps%20I%20should%20try%20to%20involve%20365-support%20on%20the%20matter%3F%20Any%20thoughts%3F%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Dear all, 

 

We are currently trying to figure out how to analyse our meeting room usage. 

We're using Exchange Online.

 

Case: 

We have around 75 meeting rooms. Our Facility services would really appreciate if we could give them some sort of data on how often the rooms are used (frequency), how many are using them etc. Their needs are in the context of "how should we shape the meeting rooms in the future, should we build more in one location, and close down some in another location and so on". 

 

We have tried powershell using comandlets "Get-CalendarDiagnosticLog" and "Get-CalendarDiagnosticAnalysis", but no luck parsing the huge amounts of data into something that makes sense. For instance, the log-date is captures, but from what I can see, not the date/time of the specific room and attendees. 

 

Help on this matter would be greatly appreciated. 

 

Sincerely

 

Torbjoern

4 Replies
Highlighted
Hi again!

Looks like this question will go unanswered. Perhaps I should try to involve 365-support on the matter? Any thoughts?
Highlighted
Thanks Klaus! We did some searches where the first article came up. My colleague tried the first one and said something about why this didn't work in our org, but we'll have another look at it for sure. I haven't seen the second one before, thanks a lot. I've just submitted this in uservoice. All things considered, MS is doing a pretty good job at the moment presenting usage reports in the new portal, although not as granular or detailed as we'd like, it's a good start and I'm sure they would appreciate our ideas as well. Please vote if you think believe that this is somewhat useful ;o) Link will be provided shortly. Seems like the uservoice-site is having issues at the moment.