CallRecords
Provides an overview of call activity in Microsoft Teams, including metadata such as call duration and type.
Table Specific Information
Select
Query the CallRecords table to get details of PeerToPeer and Group Calls on Teams. The CallRecordsId should be acquired by following instructions in Get callRecord. Custom App and Client Credentials should be used. See Creating an Entra ID (Azure AD) Application.
- CallRecordsId supports '=' operator.
The following is an example query:
SELECT * FROM CallRecords WHERE CallRecordsId = 'b6ee7caa-f730-451f-b6bd-24592a3429a7'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the call record in Microsoft Teams. |
| EndDateTime | Datetime | Timestamp indicating when the call ended. |
| JoinWebUrl | String | Web URL that participants used to join the meeting. |
| LastModifiedDateTime | Datetime | Timestamp of the most recent modification to this call record. |
| Modalities | String | Communication modes used during the call, which can include audio, video, videoBasedScreenSharing, data, and screenSharing. |
| StartDateTime | Datetime | Timestamp indicating when the call or meeting started. |
| Type | String | Specifies whether the call was peerToPeer or groupCall. |
| Version | Long | Version number of the call record for internal tracking. |
| organizer_v2_id | String | Unique identifier for the meeting organizer in Microsoft Teams. |
| organizer_v2_displayName | String | Full display name of the user who organized the meeting. |
| organizer_v2_userId | String | User ID of the meeting organizer within Microsoft Teams. |
| organizer_v2_tenantId | String | Tenant ID associated with the meeting organizer's Microsoft 365 account. |
| organizer_v2_userPrincipalName | String | User Principal Name (UPN) of the meeting organizer. |
| CallRecordsId | String | Mandatory internal column representing the call record ID, used in WHERE clauses to filter records. |