Forum Discussion

Torbjørn Meling's avatar
Torbjørn Meling
Copper Contributor
Aug 19, 2016

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

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

Resources