Microsoft Teams widgets – Single-Person Meetings over 20 Minutes
Definition
Microsoft Teams is designed to be flexible, accommodating various scenarios including instances where scheduled group calls have only one participant. The system allows these calls to proceed for the intended duration, ensuring that the user is not disconnected due to lack of participation.
This widget is particularly useful for identifying calls where a user is marked as “In a Meeting” despite no other participants joining and waiting in this meeting with no other users for over 20 minutes, which can assist in better understanding team engagement and availability.
Sample output
Widget definition
{"ViewGuid":"ee1306f8-730e-434c-8fce-70e085f6a407","Definition":{"ColumnAggregates":[{"Alias":"CallStart_feb76b0b51b1370b","Label":"Call Start","ColumnId":"CallStart","AggregateType":"Value","IsAggregate":false,"Type":-2},{"Alias":"CallTypeName_91fe1b4d808ccc7c","Label":"Call Type Name","ColumnId":"CallTypeName","AggregateType":"Value","IsAggregate":false,"Type":-2},{"Alias":"OrganizerMicrosoftUserDisplayName_7272b45bd8bff1c7","Label":"Organiser Display Name","ColumnId":"OrganizerMicrosoftUserDisplayName","AggregateType":"Value","IsAggregate":false,"Type":-2},{"Alias":"DurationMilliseconds_69db454bde281195","Label":"Call Duration","ColumnId":"DurationMilliseconds","AggregateType":"Value","IsAggregate":false,"Type":-1},{"Alias":"ParticipationMilliseconds_4297c1f8a116b755","Label":"Call Participation Time","ColumnId":"ParticipationMilliseconds","AggregateType":"Value","IsAggregate":false,"Type":-1},{"Alias":"SessionCount_c791f5478e433c3f","Label":"Session Count","ColumnId":"SessionCount","AggregateType":"Value","IsAggregate":false,"Type":-1},{"ColumnId":"OrganizerMicrosoftUserPrincipalName","IsNew":true,"Type":-2,"Alias":"OrganizerMicrosoftUserPrincipalName_b2bcd8b3e033f010","Label":"Organiser Principal Name"}],"PreFilters":[{"Symbol":"("},{"IsAggregate":false,"ColumnId":"factCallSummary_MeetingParticipantCount","FilterColumnAlias":null,"Alias":"factCallSummary_MeetingParticipantCount_b803433e6f668998","AggregateType":"Value","Operator":"Equals","Value":1,"Value2":null,"Type":2,"Label":"Meeting Participant Count"},{"Symbol":"&"},{"IsAggregate":false,"ColumnId":"factCallSummary_IsMeeting","FilterColumnAlias":null,"Alias":"factCallSummary_IsMeeting_b2b5c7d4a4e86dbd","Type":6,"Value":true,"AggregateType":"Value","Label":"Is Meeting"},{"Symbol":")"},{"Symbol":"&"},{"IsAggregate":false,"ColumnId":"OrganizerMicrosoftUserDisplayName","FilterColumnAlias":null,"Alias":"OrganizerMicrosoftUserDisplayName_e3670cf9ea099643","Operator":"Contains","Value":null,"Type":0,"AggregateType":"Value","Label":"Organiser Display Name"},{"Symbol":"&"},{"IsAggregate":false,"ColumnId":"DurationMilliseconds","FilterColumnAlias":"callDuration","Alias":"DurationMilliseconds_1e461076c8f54b22","Operator":"IsGreaterThan","Value":1200000,"Value2":0,"AggregateType":"Value","Type":13,"Label":"Call Duration"},{"Symbol":"&"},{"ColumnId":"OrganizerMicrosoftUserPrincipalName","FilterColumnAlias":null,"IsNew":true,"Operator":"IsNotBlank","Value":"","Type":0,"Alias":"OrganizerMicrosoftUserPrincipalName_5f5c83792c0e9831","Label":"Organiser Principal Name"}],"PreGroupFilters":[],"Parameters":{"SelectedTreeId":"1","DateSelectionMethod":"UseQuickDates","QuickDate":{"Type":"8","FromLocal":"01/11/2024 00:00:00","ToLocal":"30/11/2024 23:59:59"}},"GridSettings":"{\"columns\":[{\"index\":0,\"field\":\"Id\",\"width\":45.0156,\"hidden\":false},{\"index\":1,\"field\":\"CallStart_feb76b0b51b1370b\",\"width\":110.0156,\"hidden\":false},{\"index\":2,\"field\":\"CallTypeName_91fe1b4d808ccc7c\",\"width\":134,\"hidden\":false},{\"index\":3,\"field\":\"OrganizerMicrosoftUserDisplayName_7272b45bd8bff1c7\",\"width\":182.008,\"hidden\":false},{\"index\":4,\"field\":\"DurationMilliseconds_69db454bde281195\",\"width\":128.00400000000002,\"hidden\":false},{\"index\":5,\"field\":\"ParticipationMilliseconds_4297c1f8a116b755\",\"width\":188.004,\"hidden\":false},{\"index\":6,\"field\":\"SessionCount_c791f5478e433c3f\",\"width\":112.3398,\"hidden\":false},{\"index\":7,\"field\":\"OrganizerMicrosoftUserPrincipalName_b2bcd8b3e033f010\",\"width\":828.336,\"hidden\":false}],\"sortField\":\"DurationMilliseconds_69db454bde281195\",\"sortDir\":\"desc\",\"pageSize\":50}"},"DefinitionVersion":1}