PstnCalls
Displays Public Switched Telephone Network (PSTN) call records in Microsoft Teams.
テーブル固有の情報
Select
カスタムアプリおよびクライアントクレデンシャルを使用する必要があります。Entra ID（Azure AD）アプリケーションの作成 を参照してください。 本製品 は Microsoft Teams API を使用して、以下のカラムと演算子で作成されたWHERE 句条件を処理します。その他のフィルタはクライアントサイドで本製品 内部で処理されます。
- FromDate は、'=' 演算子をサポートします。
- ToDate は、'=' 演算子をサポートします。
次にクエリの例を示します。
SELECT * FROM PstnCalls WHERE FromDate = '2021-01-01' SELECT * FROM PstnCalls WHERE FromDate = '2021-01-01' AND ToDate = '2021-02-09'
Note：FromDate およびToDate は必須パラメータであり、指定されていない場合はデフォルトの日付を日付範囲90日で使用します。
Columns
| Name | Type | Description |
| Id | String | Unique identifier for the PSTN (Public Switched Telephone Network) call record. |
| CallId | String | Identifier for the specific call within Microsoft Teams. |
| UserId | String | Unique identifier of the user associated with the call. |
| UserPrincipalName | String | User Principal Name (UPN) of the user who made or received the call. |
| UserDisplayName | String | Display name of the user involved in the call. |
| StartDateTime | Edm.DateTimeOffset | Timestamp indicating when the PSTN call started. |
| EndDateTime | Edm.DateTimeOffset | Timestamp indicating when the PSTN call ended. |
| Duration | Integer | Total duration of the call in seconds. |
| Charge | Edm.Double | Monetary charge for the PSTN call. |
| CallType | String | Type of call, such as inbound or outbound. |
| Currency | String | Currency in which the charge is calculated. |
| CallerNumber | String | Phone number of the caller. |
| CalleeNumber | String | Phone number of the callee. |
| UsageCountryCode | String | Country code representing where the PSTN usage occurred. |
| TenantCountryCode | String | Country code for the Microsoft 365 tenant associated with the call. |
| ConnectionCharge | Edm.Double | One-time connection charge for the PSTN call. |
| DestinationName | String | Name of the call destination, such as a city or region. |
| ConferenceId | String | Identifier for the conference when the call is part of a conference session. |
| LicenseCapability | String | License capability of the user at the time of the call. |
| InventoryType | String | Type of inventory resource used for the call, such as service numbers or user numbers. |
| FromDate | Edm.Date | Start date for filtering PSTN call records to retrieve. |
| ToDate | Edm.Date | End date for filtering PSTN call records to retrieve. |