CallRecordSessions
Lists sessions within Microsoft Teams calls, with details on session start and end times.
Table Specific Information
Select
Query the CallRecordSessions table to get details of PeerToPeer and Group Call session information 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
- CallRecordSessions supports '=' operator.
The following is an example query:
SELECT * FROM CallRecordSessions WHERE CallRecordsId = 'b6ee7caa-f730-451f-b6bd-24592a3429a7'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the call record session in Microsoft Teams. |
| Callee_UserAgent_ApplicationVersion | String | Version of the application used by the callee's user agent during the session. |
| Callee_UserAgent_HeaderValue | String | Header value from the callee's user agent during the session. |
| Caller_UserAgent_ApplicationVersion | String | Version of the application used by the caller's user agent during the session. |
| Caller_UserAgent_HeaderValue | String | Header value from the caller's user agent during the session. |
| EndDateTime | Datetime | Timestamp indicating when the call session ended. |
| FailureInfo_Reason | String | Reason for the call session failure, if applicable. |
| FailureInfo_Stage | String | Stage at which the call session failure occurred, if applicable. |
| Modalities | String | Communication modes used in the session, which can include audio, video, videoBasedScreenSharing, data, and screenSharing. |
| StartDateTime | Datetime | Timestamp indicating when the call session started. |
| CallRecordsId | String | Mandatory internal column representing the call record ID, used in WHERE clauses to filter records. |