WPA Count in office and teams meetings

lorinamuca
Valued Contributor II
Valued Contributor II

Hello,

I am new in WPA and i am trying to calculate and distinguish the number of meetings taken in the office and the number of meetings taken in teams. Is there a way to retrieve this information form WPA? I tried to find this information from the Microsoft 365 usage analytics but i didn't find it there you can find the number of mails and meetings from different apps but not those meetings taken within the office building.

Thank you in advance.

1 ACCEPTED SOLUTION

I do believe it will work...for every metric you want to look at like meeting or meeting hours you can can customize based on the meeting resource....I would run a test query using the meeting query and include meeting resource in the in the organization data to verify

If Microsoft Teams Meeting shows up as a resource...you should have a person query metric with the meeting resource equal to "Microsoft Teams Meeting" and another not equal to "Microsoft Teams Meeting"...

If Microsoft Teams Meeting does not show up as a resource in the meeting query...you should have a person query metric with the meeting resource equal to "" [means blank] and another not equal to ""
It may take a little experimenting to get it to register, but it should work...

View solution in original post

4 REPLIES 4

Oliver_S_Beard
Valued Contributor II
Valued Contributor II

I am no expert in the subject, but you can actually have it look at meeting resources to determine what type of meeting it is dependent on how outlook is setup in your company. At my company, we have rooms designated in a certain way and then we have our online meetings designated another way so we can actually use this method to filter between online and in-office meetings. I think this will require understanding how your company uses outlook and what are the distinguishing differences between an office meeting and a teams meeting for example. If we had a few examples of each, then we may be able to help with the query development. 

See below for an example where you can use meeting resources as a filtering mechanism:

Oliver_S_Beard_0-1639403121989.png

 

Hi Oliver,

Thank you for the quick response.

I my company we distinguish meetings from the "Location" option if it's a teams meeting in the location we will find written in the location: "Microsoft teams meeting" otherwise if the meeting is taken in office in the location we will find written the name of the meeting room.

As is the actual setup of meetings do you think we could be able to make the difference? 

Thank you. 

Capture.PNG

I do believe it will work...for every metric you want to look at like meeting or meeting hours you can can customize based on the meeting resource....I would run a test query using the meeting query and include meeting resource in the in the organization data to verify

If Microsoft Teams Meeting shows up as a resource...you should have a person query metric with the meeting resource equal to "Microsoft Teams Meeting" and another not equal to "Microsoft Teams Meeting"...

If Microsoft Teams Meeting does not show up as a resource in the meeting query...you should have a person query metric with the meeting resource equal to "" [means blank] and another not equal to ""
It may take a little experimenting to get it to register, but it should work...

Pawel_Gorski
Valued Contributor II
Valued Contributor II

Hi @lorinamuca , have you tried Oliver's approach? Any useful results?

Recommendations for you