PSTN 使用报告PSTN usage report

新的 Skype for Business 管理中心报告区域显示你的组织中的通话和音频会议活动。The new Skype for Business Admin Center Reports area shows you calling and audio conferencing activity in your organization. 它使您能够深入查看报表,让您更细致地了解每个用户的活动。It enables you to drill into reports to give you more granular insight about the activities of each user. 例如,你可以使用 Skype for Business PSTN 使用详细信息报告查看拨入/拨出呼叫的通话时长以及这些呼叫的费用。For example, you can use the Skype for Business PSTN usage details report to see the number of minutes spent in inbound/outbound calls and cost for these calls. 你可以查看音频会议 PSTN 使用详细信息,包括通话费用,以便你可以了解你的使用情况并拨打帐单详细信息以确定你的组织中的使用情况。You can view Audio Conferencing PSTN usage details including the cost of the call so that you can understand your usage and call billing details to determine usage within your organization.

有关可用报表的详细信息,请查看报表概述Check out the Reports overview for more reports that are available.

此报告以及其他 Skype for Business 报告提供了有关活动的详细信息,包括您的组织内的通话使用情况。This report, along with the other Skype for Business reports, gives you details on activity including calling usage across your organization. 在调查、规划和为组织制定其他业务决策以及设置通信信用点数时,这些详细信息非常有用。These details are very helpful when you investigating, planning, and making other business decisions for your organization and for setting up Communications Credits.

备注

当您以管理员身份登录到 Microsoft 365 管理中心时,您可以看到所有 Skype for Business 报告。You can see all of the Skype for Business reports when you log on as an administrator to the Microsoft 365 admin center.

如何获取 Skype for Business PSTN 使用详细信息报告How to get to the Skype for Business PSTN usage details report

显示 Skype for Business 徽标的图标 使用 Skype for Business 管理中心An icon showing the Skype for Business logo Using the Skype for Business admin center

  • 转到管理中心 >管理中心 > Skype for business 管理中心 > 报告 > PSTN 使用详细信息Go to the admin center > Admin centers > Skype for Business admin center > Reports > PSTN usage details.

    备注

    你可能无法看到此处所示的所有产品和报告,具体取决于你拥有的 Microsoft 365 或 Office 365 订阅。Depending on the Microsoft 365 or Office 365 subscription you have, you might not see all the products and reports that are shown here.

解释 Skype for Business PSTN 使用情况报告Interpret the Skype for Business PSTN usage report

你可以通过查看显示的每一列了解用户的 Skype for Business PSTN 使用情况。You can get a view into your user's Skype for Business PSTN usage by looking at each of the columns that are displayed.

以下是此报告的外观。This is what the report looks like.

Skype for BUSINESS PSTN 使用报告 Skype for Business PSTN usage report


第一
该表格显示了按用户细分的全部 PSTN 使用情况。The table shows you a breakdown of the all PSTN usage per user. 此示例显示分配有 Skype for Business 的所有用户及其 PSTN 使用情况。This shows all users that have Skype for Business assigned to them and their PSTN usage. 你可以添加/删除表格的列。You can add/remove columns to the table.

  • 通话id是呼叫的呼叫 id。Call ID is the call ID for a call. 它是呼叫 Microsoft 服务支持时使用的呼叫的标识符。It is an identifier for the call that is used when calling Microsoft service support.

  • " 用户 ID"是用户的登录名。User ID is the user's sign in name.

  • "电话号码" 是接收入站通话呼叫或拨出拨出电话的号码的 Skype for business 电话号码。Phone number is the Skype for Business phone number that received the call for inbound calls or the number dialed for outbound calls.

  • 用户位置是用户所在的国家/地区。User location is the country/region where the user is located.

  • 呼叫方 ID是呼叫者的电话号码(来电显示),用于拨入呼叫、呼叫发出的号码或 Skype for business 号码,呼叫来自该电话拨出的电话。Caller ID is caller's telephone number (Caller ID) for inbound calls, the number from which the call originated or the Skype for Business number from which the call originated for outbound calls.

  • 呼叫类型指示呼叫是 PSTN 传出还是传入呼叫,以及呼叫类型,例如由用户或音频会议发出的呼叫。Call type is whether the call was a PSTN outgoing or incoming call and the type of call such as a call placed by a user or an audio conference. 您可能看到的呼叫类型如下:The call types you may see are:

    通话计划呼叫类型Calling Plan Call Types

    • user_in (用户收到入站 PSTN 呼叫)user_in (the user received an inbound PSTN call)
    • user_out (用户发出出站 PSTN 呼叫)user_out (the user placed an outbound PSTN call)
    • user_out_conf (用户向呼叫添加2个或更多 PSTN 参与者,如 "3 路会议呼叫")user_out_conf (the user added 2 or more PSTN participants to the call such as a 3-way conference call)
    • user_out_transfer (用户已将呼叫转移到 PSTN 号码)user_out_transfer (the user transferred the call to a PSTN number)
    • user_out_forwarding (用户将呼叫转接到 PSTN 号码)user_out_forwarding (the user forwarded the call to a PSTN number)

    音频会议呼叫类型Audio Conferencing Call Types

    • conf_in (对音频会议桥的入站呼叫)。conf_in (an inbound call to the Audio Conferencing bridge). 对于此呼叫类型的记录,"用户 ID " 列中指定的用户对应于会议的组织者。For records of this call type, the user specified in the User ID column corresponds to the organizer of the meeting.
    • conf_out (来自音频会议网桥的出站呼叫,通常用于向会议添加 PSTN 号码)。conf_out (an outbound call from the Audio Conferencing bridge, usually to add a PSTN number to the conference). 对于此呼叫类型的记录,"用户 ID " 列中指定的用户对应于会议的组织者。For records of this call type, the user specified in the User ID column corresponds to the organizer of the meeting.

    统一通信应用程序(UCAP)Unified Communication Applications (UCAP)

    • ucap_in (对 UC 应用程序(如自动助理或呼叫队列)的入站 PSTN 呼叫ucap_in (an inbound PSTN call to the UC application such as auto attendant or call queue)
    • ucap_out (来自 UC 应用程序的出站 PSTN 呼叫,如自动助理或呼叫队列)ucap_out (an outbound PSTN call from the UC application such as auto attendant or call queue) > [!NOTE] > 从 UC 应用程序(如自动助理或呼叫队列)转移到用户的呼叫不会显示在 PSTN 使用报告中,因为这些呼叫条是对等(P2P)音频呼叫。Calls that were transferred to a user from the UC application such as an auto attendant or call queue will not appear in the PSTN usage report as these call legs are peer to peer (P2P) audio calls. 你可以在 "工具 > Skype for business 呼叫分析" 下访问 Skype for Business 管理中心中的 P2P 呼叫,并按用户名或 SIP 地址进行搜索,按日期/时间和/或始发 CLID (呼叫行 ID)将呼叫关联起来。You may access the P2P calls in the Skype for Business Admin Center under "Tools > Skype for Business Call Analytics" and search by User Name or SIP address correlating the call by date/time and/or originating CLID (calling line ID).

    "国内/国际" 告诉您所拨的电话是否被视为国内(在国家/地区内)还是国际(国家/地区外)的电话(基于用户的位置)。Domestic/International tells you whether the call that was placed was considered domestic (within a country/region) or international (outside of a country/region) based on the user's location.

  • "目的地已拨" 表示拨打的国家/地区目的地的名称,如法国、德国或美国(美国)。Destination dialed is the name of the country/region destination that is dialed such as France, Germany, or the United States (U.S.).

  • Number type指由用户电话号码、服务或免费电话号码组成的电话号码类型。Number type is the type of phone number that is from a user's phone number, a service or toll-free number.

  • " 开始时间(UTC)"是开始或拨打呼叫的时间。Start Time (UTC) is the time that the call was started or placed.

  • " 持续时间"是接听呼叫的时间。Duration is how long the call was connected.

  • ConfID是音频会议的会议 ID。ConfID is the conference ID of the audio conference.

  • "费用" 表示支付给您的帐户的通话的金额或费用。Charge is the amount of money or cost of the call that is being charged to your account.

  • 货币是用于计算通话费用的货币类型。Currency is the type of currency that is used to calculate the cost of the call.

  • 功能是用于通话的许可证。Capability is the license used for the call. 你可能会看到的许可证类型如下:The license types you may see are:

    • MCOPSTNPP -通讯信用点数MCOPSTNPP - Communications Credits
      MCOPSTN1 -国内通话计划(3000,美国/1200 最少欧盟计划)MCOPSTN1 - Domestic Calling Plan (3000 min US / 1200 min EU plans)
    • MCOPSTN2 -国际通话计划MCOPSTN2 - International Calling Plan
    • MCOPSTN5 -国内通话计划(120分钟通话计划)MCOPSTN5 - Domestic Calling Plan (120 min calling plan)
    • MCOPSTN6 -国内通话计划(240 min 通话计划)注意:可用性有限MCOPSTN6 - Domestic Calling Plan (240 min calling plan) Note: Limited Availability
    • MCOMEETADD -音频会议MCOMEETADD - Audio Conferencing
    • MCOMEETACPEA -每分钟支付的音频会议MCOMEETACPEA - Pay Per Minute Audio Conferencing

备注

如果您想要运行报告以仅包括您的通话或会议订阅中未包括的每分钟费率通话,请使用 "MCOPSTNPP" 功能筛选报告。If you would like to run a report to include only pay per minute calls that are not included in your calling or conferencing subscription, filter the report with capability "MCOPSTNPP". 这样做将提供所有按分钟付费通话的明细。Doing so will provide an itemization of all pay per minute calls. 对于每分钟支付的音频会议,请按 "MCOMEETACPEA" 而不是 "MCOPSTNPP" 进行筛选。For pay per minute audio conferencing, filter by "MCOMEETACPEA" instead of "MCOPSTNPP".

备注

在某些字段中,您可能还会看到 "无数据"。You may also see "no data" in some fields. "无数据" 表示该字段不适用于通话类型或功能。"No data" means the field is not applicable to the call type or capability.

备注

如果您有 Telstra 或 Softbank 通话计划,则在 PSTN 使用报告中将看不到任何通话详细记录。If you have a Telstra or Softbank calling plan, you will not see any call detail records in the PSTN usage report. 请联系 Telstra 或 Softbank,以满足你的报告需求。Please contact Telstra or Softbank for your reporting needs.


第二Number 2
如果你希望创建将一列或多列中的所有数据进行分组的视图,请单击某个列并将其拖动到" 若要按特定列进行分组,请将列标题拖至此处"。Click to drag a column to To group by a particular column, drag and drop the column header here if you want to create a view that groups all of the data in one or more columns.


导出 PSTN 使用情况报告Exporting PSTN usage report

单击或点击 "导出到 Excel " 按钮可下载 PSTN 使用情况报告。Clicking or tapping the Export to Excel button lets you to download the PSTN usage report. 您可以从当前日期导出一年的数据,除非特定国家/地区的法规禁止将数据保留12个月。You can export data up to one year from the current date unless country-specific regulations prohibit retention of the data for 12 months.

此操作会导出所有用户数据并允许你执行简单的排序和筛选以进行更详细的分析。This exports data of all users and enables you to do simple sorting and filtering for further analysis.

导出过程可能需要几秒钟到几分钟才能完成,具体取决于数据的数量。Export process can take from a few seconds to several minutes to complete, depending on the quantity of the data. 当服务器完成导出时,你将收到名为 "Calls. []" 的 zip 文件 identifier 。zip",其中标识符是导出的唯一 ID,可用于故障排除。When the server completes the export, you will receive a zip file named "Calls.Export.[identifier].zip", with the identifier being an unique ID for the export, which can be used for troubleshooting.

如果既有通话计划又有直接路由,则导出的文件可能包含两个产品的数据。If you have both Calling Plans and Direct Routing, the exported file may contain data for both products. PSTN 使用报告文件将具有文件名 "PSTN. []" UTC date 。csv"。PSTN usage report file will have filename "PSTN.calls.[UTC date].csv". 除了 PSTN 和直接路由文件,存档中还包含 "parameters.js" 文件,并具有所选的导出时间范围和功能(如果有)。In addition to PSTN and Direct Routing files, the archive contains file "parameters.json", with the selected export time range and Capabilities (if any).

导出的文件是一个逗号分隔值(CSV)文件,符合RFC 4180标准。Exported file is a Comma Separated Values (CSV) file, compliant with RFC 4180 standard. 该文件可以在 Excel 或任何其他符合标准的编辑器中打开,无需任何转换。The file can be opened in Excel or any other standards-compliant editor without requiring any transformations.

CSV 的第一行包含列名称。The first row of the CSV contains column names.

导出中的字段Fields in the export

导出的文件包含在联机报表中不可用的其他字段。Exported file contains additional fields that are not available in the online report. 这些可用于疑难解答和自动化工作流。These can be used for troubleshooting and automated workflows.

# 名称Name 数据类型(SQL Server)Data type (SQL Server) 说明Description
00 UsageIdUsageId uniqueidentifier 唯一的呼叫标识符Unique call identifier
11 通话 IDCall ID nvarchar(64) 通话标识符。Call identifier. 不保证唯一性Not guaranteed to be unique
22 会议 IDConference ID nvarchar(64) 音频会议的 IDID of the audio conference
33 用户位置User Location nvarchar(2) 用户的国家/地区代码, ISO 3166-1 alpha-2Country code of the user, ISO 3166-1 alpha-2
44 AAD ObjectIdAAD ObjectId uniqueidentifier 在 Azure Active Directory 中调用用户的 ID。Calling user's ID in Azure Active Directory.
对于 bot 呼叫类型(ucap_in,ucap_out),此和其他用户信息将为 null/空This and other user info will be null/empty for bot call types (ucap_in, ucap_out)
55 UPNUPN nvarchar(128) Azure Active Directory 中的 UserPrincipalName (登录名称)。UserPrincipalName (sign in name) in Azure Active Directory.
这通常与用户的 SIP 地址相同,并且可以与用户的电子邮件地址相同This is usually the same as user's SIP Address, and can be same as user's e-mail address
66 用户显示名称User Display Name nvarchar(128) 用户的显示名称Display name of the user
77 来电显示Caller ID nvarchar(128) 为拨入电话或拨出电话拨出的电话号码接收呼叫的号码。Number that received the call for inbound calls or the number dialed for outbound calls. E. 164格式E.164 format
8 呼叫类型Call Type nvarchar(32) 呼叫是 PSTN 出站通话还是入站呼叫以及呼叫类型,例如由用户或音频会议发出的呼叫Whether the call was a PSTN outbound or inbound call and the type of call such as a call placed by a user or an audio conference
db-99 号码类型Number Type nvarchar(16) 用户的电话号码类型,例如免费号码的服务User's phone number type, such as a service of toll-free number
1010 国内/国际Domestic/International nvarchar(16) 呼叫是国内的(在国家或地区内)还是国际(在国家或地区之外)基于用户的位置Whether the call was domestic (within a country or region) or international (outside a country or region) based on the user's location
1111 已拨目标Destination Dialed nvarchar(64) 拨打的国家或地区Country or region dialed
12 目标号码Destination Number nvarchar(32) 164格式拨打的号码Number dialed in E.164 format
1313 开始时间Start Time datetimeoffset 调用开始时间(UTC, ISO 8601Call start time (UTC, ISO 8601)
1414 结束时间End Time datetimeoffset 通话结束时间(UTC, ISO 8601Call end time (UTC, ISO 8601)
15 持续秒数Duration Seconds int 通话的连接时间How long the call was connected
utf-1616 连接费Connection Fee numeric(16, 2) 连接费价格Connection fee price
17 收费Charge numeric(16, 2) 为您的帐户收取的通话金额或通话费用Amount of money or cost of the call that is charged to your account
1818 货币Currency nvarchar(3) 用于计算通话费用的货币类型(ISO 4217Type of currency used to calculate the cost of the call (ISO 4217)
1919 功能Capability nvarchar(32) 用于通话的许可证The license used for the call

想要查看其他 Skype for Business 报告?Want to see other Skype for Business reports?

管理中心中的活动报表Activity Reports in the admin center