SSIS Components for Microsoft Teams

Build 25.0.9434

CallRecords

Provides an overview of call activity in Microsoft Teams, including metadata such as call duration and type.

テーブル固有の情報

Select

CallRecord テーブルをクエリして、Teams のピアツーピアおよびグループ通話セッションセグメントの詳細を取得します。 CallRecordsId は、callRecord の取得の説明に従って取得してください。 カスタムアプリおよびクライアントクレデンシャルを使用する必要があります。Entra ID(Azure AD)アプリケーションの作成 を参照してください。

  • CallRecordsId は、'=' 演算子をサポートします。

次にクエリの例を示します。

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434