在通话质量仪表板中上载租户和构建数据 (CQD) Upload tenant and building data in Call Quality Dashboard (CQD)

若要充分利用通话质量仪表板 (CQD) ,建议你上载租户并生成数据。To get the most out of Call Quality Dashboard (CQD), we recommend that you upload your tenant and building data. 有2种类型的租户数据文件, 生成终结点There are 2 types of tenant data files, Building and Endpoint.

你可以 在此处下载示例租户数据模板。You can download a sample tenant data template here. 有关生成映射的帮助,请参阅为 CQD 创建构建地图For help with building mapping, read Create a building map for CQD.

在 "CQD 摘要报告" 仪表板中,从 "CQD设置" 菜单中选择 "租户数据上传", (位于 CQD ") 顶部的齿轮图标。From the CQD Summary Reports dashboard, select Tenant Data Upload from the CQD Settings menu (a gear icon at the top of CQD). 在此,管理员可以上载其组织的建筑物和终结点信息,例如 IP 地址和地理信息的映射、映射每个无线访问点及其 MAC 地址等。From here, admins can upload their organization's building and endpoint information, such as mapping of IP addresses and geographical information, mapping each wireless access point and its MAC address, etc.

  1. 从团队管理中心打开 CQD (,或在) 中 https://cqd.teams.microsoft.com ,选择右上角的齿轮图标,然后从 "摘要报告" 页面中选择 "租户数据上传"。Open CQD (from the Teams admin center, or at https://cqd.teams.microsoft.com), then select the gear icon in the upper-right corner and choose Tenant Data Upload from the Summary Reports page.

    在上载数据时出现的对话框的屏幕截图

  2. 或者,如果你首次访问 CQD,系统将要求你上载数据。Alternatively, if this is your first time visiting CQD, you'll be asked to upload building data. 你可以选择 " 立即上载 " 以快速导航到 租户数据上载 页面。You can select Upload Now to quickly navigate to the Tenant Data Upload page.

    通知用户上载生成数据的横幅的屏幕截图

  3. 在 " 租户数据上载 " 页面上,选择 " 浏览 " 以选择数据文件。On the Tenant Data Upload page, select Browse to choose a data file.

  4. 选择数据文件后,指定 " 开始日期 ",(可选)指定结束日期。After selecting a data file, specify Start date and, optionally, specify an end date.

  5. 选择 " 开始日期" 后,选择 " 上传 " 将文件上传到 CQD。After selecting Start date, select Upload to upload the file to CQD.

    在上载文件之前,它将经过验证。Before the file is uploaded, it's validated. 如果验证失败,则会显示一条错误消息,要求你更正该文件。If validation fails, an error message is displayed requesting that you correct the file. 下图显示了当数据文件中的列数不正确时出现的错误。The following figure shows an error occurring when the number of columns in the data file is incorrect.

    显示生成数据上载错误的对话框示例

  6. 如果验证期间没有出现错误,文件上载将成功。If no errors occur during validation, the file upload will succeed. 然后,你可以在 "我的上 " 表中看到上载的数据文件,其中显示了当前租户在该页面底部的所有上载文件的完整列表。You can then see the uploaded data file in the My uploads table, which shows the full list of all uploaded files for the current tenant at the bottom of that page.

备注

最多可能需要四个小时才能完成处理生成文件。It can take up to four hours to finish processing the building file.

如果你已经上载了一个生成文件,但需要添加可能已错过或排除的子网,请通过添加新的子网、删除当前文件并重新上载新编辑的文件来修改原始文件。If you've already uploaded a building file and need to add subnets that might have been missed or excluded, modify the original file by adding the new subnets, remove the current file, and re-upload the newly edited file. CQD 中只能有一个活动的构建数据文件。There can be only one active building data file in CQD.

上载构建数据文件Upload building data file

CQD 中的第一种类型的租户数据文件是 生成 数据文件。The first type of tenant data file in CQD is the Building data file. 通过展开 "网络 + NetworkRange" 列,然后将 "子网" 列联接到呼叫记录的第一个子网或 "第二个子网" 列中,显示建筑物、城市、国家或地区信息,从而派生出子网列。The Subnet column is derived by expanding the Network+NetworkRange column, then joining the Subnet column to the call record’s First Subnet or Second Subnet column to show Building, City, Country, or Region information. 你上载的数据文件的格式必须满足以下条件才能在上载之前通过验证检查:The format of the data file you upload must meet the following criteria to pass the validation check before upload:

  • 文件必须是 tsv 文件 (列由选项卡) 或 .csv 文件分隔, (列之间用) 逗号分隔。The file must be either a .tsv file (columns are separated by a TAB) or a .csv file (columns are separated by a comma).

  • 数据文件不包含表格标题行。The data file doesn't include a table header row. 数据文件的第一行应为真实数据,而不是标题标签(如 "Network")。The first line of the data file is expected to be real data, not header labels like "Network".

  • 文件中的数据类型只能是 String、Integer 或 Boolean。Data types in the file can only be String, Integer, or Boolean. 对于整数数据类型,值必须是一个数值。For the Integer data type, the value must be a numeric value. 布尔值必须是0或1。Boolean values must be either 0 or 1.

  • 如果列使用字符串数据类型,则数据字段可以为空,但仍须由制表符或逗号分隔。If a column uses the String data type, a data field can be empty but must still be separated by a tab or comma. 空数据字段只是分配一个空字符串值。An empty data field just assigns an empty String value.

  • 每一行必须有14列,每一列必须具有相应的数据类型,并且列必须按下表中列出的顺序 (逗号或制表符分隔) :There must be 14 columns for each row, each column must have the appropriate data type, and the columns must be in the order listed in the following table (comma or tab delimited):

    构建数据文件格式Building data file format

    列名称Column name 数据类型Data type 示例Example 指引Guidance
    NetworkIPNetworkIP StringString 192.168.1.0192.168.1.0 必需Required
    NetworkNameNetworkName StringString 美国/西雅图/西雅图-海-1USA/Seattle/SEATTLE-SEA-1 必需1Required1
    NetworkRangeNetworkRange 数字Number 26 必需Required
    BuildingNameBuildingName StringString 西雅图-海-1SEATTLE-SEA-1 必需1Required1
    OwnershipTypeOwnershipType StringString 制定Contoso 可选Optional
    BuildingTypeBuildingType StringString 终止IT Termination 可选Optional
    BuildingOfficeTypeBuildingOfficeType StringString 技术Engineering 可选Optional
    城市City StringString 西雅图Seattle 推荐Recommended
    ZipCodeZipCode StringString 9800198001 推荐Recommended
    该国Country StringString 我们US 推荐Recommended
    省/市/自治区State StringString WAWA 推荐Recommended
    区域Region StringString MSUSMSUS 推荐Recommended
    InsideCorp2InsideCorp2 BoolBool 11 必需Required
    ExpressRoute3ExpressRoute3 BoolBool 00 必需Required
    VPNVPN BoolBool 00 可选Optional

    1 虽然 CQD 不是必需的,但模板配置为显示建筑物和网络名称。1 While not required by CQD, the templates are configured to display Building and Network name.

    2 此设置可用于反映子网是否位于企业网络内。2 This setting can be used to reflect whether or not the subnet is inside the corporate network. 你可以自定义其他用途的用法。You can customize usage for other purposes.

    3 此设置可用于反映网络是否使用 Azure ExpressRoute。3 This setting can be used to reflect whether or not the network uses Azure ExpressRoute. 你可以自定义其他用途的用法。You can customize usage for other purposes.

    示例行:Sample row:

    192.168.1.0,USA/Seattle/SEATTLE-SEA-1,26,SEATTLE-SEA-1,Contoso,IT Termination,Engineering,Seattle,98001,US,WA,MSUS,1,0,0

重要

网络范围可用于表示具有单个路由前缀) 的多个子网的 supernet (组合。The network range can be used to represent a supernet (combination of several subnets with a single routing prefix). 将检查所有新的生成上载,查找任何重叠区域。All new building uploads will be checked for any overlapping ranges. 如果你以前上载了一个生成文件,则应下载当前文件,然后重新上载它以标识任何重叠,并在再次上载之前修复该问题。If you have previously uploaded a building file, you should download the current file and re-upload it to identify any overlaps and fix the issue before uploading again. 以前上载的文件中的任何重叠都可能会导致向报表中的建筑物进行错误的子网映射。Any overlap in previously uploaded files may result in the wrong mappings of subnets to buildings in the reports. 某些 VPN 实现不能准确报告子网信息。Certain VPN implementations do not accurately report the subnet information.

"VPN" 列是可选的,默认值为0。The VPN column is optional and will default to 0. 如果 VPN 列的值设置为1,则该行表示的子网将完全展开,以匹配子网内的所有 IP 地址。If the VPN column’s value is set to 1, the subnet represented by that row will be fully expanded to match all IP addresses within the subnet. 请谨慎使用,并且仅针对 VPN 子网,因为完全展开这些子网将对涉及生成数据的查询的查询时间产生负面影响。Please use this sparingly and only for VPN subnets since fully expanding these subnets will have a negative impact on query times for queries involving building data.

SupernettingSupernetting

你可以使用 supernetting,通常称为无类别的域间路由 (CIDR,) 代替定义每个子网。You can use supernetting, commonly called Classless Inter-Domain Routing (CIDR,) in place of defining each subnet. Supernet是共享单个路由前缀的若干子网的组合。A supernet is a combination of several subnets that share a single routing prefix. 你可以使用 supernetted 地址,而不是为每个子网添加条目。Instead of adding an entry for each subnet, you can use the supernetted address. 支持 Supernetting,但我们不建议使用它。Supernetting is supported, but we don't recommend using it.

例如,Contoso 的市场营销大楼由以下子网组成:For example, Contoso's marketing building is made up of the subnets below:

  • 10.1.0.0/24-第一层10.1.0.0/24—first floor
  • 10.1.1.0/24-第二层10.1.1.0/24—second floor
  • 10.1.2.0/24-第三个楼层10.1.2.0/24—third floor
  • 10.1.3.0/24-第四个楼层10.1.3.0/24—fourth floor

你可以使用 supernetted 地址(在本例中为 10.1.0.0/22),而不是为每个子网添加条目。Instead of adding an entry for each subnet, you can use the supernetted address—in this example, 10.1.0.0/22.

  • Network = 10.1.0。0Network = 10.1.0.0
  • 网络范围 = 22Network Range = 22

在实现 supernetting 之前,需要考虑以下几点:Here are a few things to consider before you implement supernetting:

  • Supernetting 只能在具有8位到28位掩码的子网映射中使用。Supernetting can only be used in a subnet mapping with 8-bit to 28-bit mask.

  • Supernetting 花费的时间更少,但它以减少数据丰富的成本为代价。Supernetting takes less time up front, but it comes at the cost of reducing the richness of your data. 假设存在涉及子网10.1.2.0 的质量问题。Let's say there's a quality problem involving subnet 10.1.2.0. 如果你已实现 supernetting,则不会知道子网所在位置或 (的网络类型(例如,实验室) )。If you implemented supernetting, you won't know where in the building the subnet is located or what type of network it is (for example, a lab). 如果您已为建筑物和上传的地板位置信息定义了所有子网,您将能够看到这种区别。If you'd defined all the subnets for a building and uploaded floor location information, you'd be able to see that distinction.

  • 请务必确保 supernetted 地址正确,并且不会捕获不需要的子网。It's important to ensure that the supernetted address is correct and isn't catching unwanted subnets.

  • 在数据中查找192.168.0.0 非常常见。It's quite common to find 192.168.0.0 in data. 对于许多组织,这表示用户在家中。For many organizations, this indicates that the user is at home. 对于其他人,这是卫星办公室的 IP 地址方案。For others, this is the IP address scheme for a satellite office. 如果你的组织具有使用此配置的办事处,则不要将其包含在你的构建文件中,因为很难通过使用 公共子网来区分家庭网络和内部网络。If your organization does have offices that use this configuration, don't include it in your building file because it's difficult to distinguish between home and internal networks by using common subnets.

重要

网络范围可用于表示 supernet。The network range can be used to represent a supernet. 将检查所有新生成数据文件上是否有任何重叠区域。All new building data file uploads will be checked for any overlapping ranges. 如果你以前上载了一个生成文件,你应该下载当前文件并再次上载它以识别任何重叠并解决问题。If you've previously uploaded a building file, you should download the current file and upload it again to identify any overlaps and fix the issue. 以前上载的文件中的任何重叠都可能会导致向报表中的建筑物进行错误的子网映射。Any overlap in previously uploaded files might result in the wrong mappings of subnets to buildings in the reports.

VPNVPN

(QoE) 客户端发送到 Microsoft 365 或 Office 365 (CQD 数据来源)的体验的质量,包括 VPN 标志。The quality of experience (QoE) data that clients send to Microsoft 365 or Office 365—which is where CQD data is sourced from—includes a VPN flag. CQD 将看到这是第一个 VPN 和第二个 VPN 维度。CQD will see this as the First VPN and Second VPN dimensions. 但是,此标志依赖于 VPN 供应商向 Windows 报告,VPN 网络适配器已注册为远程访问适配器。However, this flag relies on VPN vendors' reporting to Windows that the VPN network adapter registered is a Remote Access adapter. 并非所有 VPN 供应商都正确注册远程访问适配器。Not all VPN vendors properly register Remote Access adapters. 因此,你可能无法使用内置的 VPN 查询筛选器。Because of this, you might not be able to use the built-in VPN query filters. 使用上面所述的 VPN 列准确标记和标识 VPN 子网。Use the VPN column discussed above to accurately mark and identify VPN subnets. 将 VPN 网络标记为易于在报表中进行标识也是一种好做法。It is also good practice to label your VPN networks for easy identification in your reports. 下面是两个有关如何标记 VPN 子网的示例:Below are two examples of how to label your VPN subnets:

  • 通过在此字段中输入 VPN 子网的 "VPN" 来定义 网络名称Define a Network Name by entering "VPN" in this field for VPN subnets.

    使用网络名称显示 VPN 的 QCD 报告屏幕截图

  • 通过在此字段中输入 VPN 子网的 "VPN" 来定义 建筑物名称Define a Building Name by entering "VPN" in this field for VPN subnets.

    显示使用建筑物名称的 VPN 的 QCD 报告屏幕截图

备注

在基础连接为无线连接时,misidentify 的 VPN 连接将网络连接类型作为有线。VPN connections have been known to misidentify the network connection type as wired when the underlying connection is wireless. 在通过 VPN 连接查看高质量时,无法假定已准确识别连接类型。When looking at quality over VPN connections, you can't assume that the connection type has been accurately identified.

终结点数据文件Endpoint data file

另一种类型的 CQD 租户数据文件是 终结点 数据文件。The other type of CQD tenant data file is the Endpoint data file. 在调用记录的第一个客户端终结点名称列或第二个客户端终结点名称列中使用列值来显示终结点的 "创建"、"模型" 或 "类型" 信息。The column values are used in the call record’s First Client Endpoint Name or Second Client Endpoint Name column to show Endpoint Make, Model, or Type information. 你上载的数据文件的格式必须满足以下条件才能在上载之前通过验证检查:The format of the data file you upload must meet the following criteria to pass the validation check before upload:

  • 文件必须是 tsv 文件 (列由选项卡) 或 .csv 文件分隔, (列之间用) 逗号分隔。The file must be either a .tsv file (columns are separated by a TAB) or a .csv file (columns are separated by a comma).

  • 数据文件的内容不包含表格标题。The content of the data file doesn't include table headers. 数据文件的第一行应为真实数据,而不是标题标签(如 "终结点")。The first line of the data file is expected to be real data, not a header label like "EndpointName".

  • 所有六列仅使用字符串数据类型。All six columns use the String data type only. 允许的最大长度为64个字符。The maximum allowed length is 64 characters.

  • 数据字段可以为空,但仍须由制表符或逗号分隔。A data field can be empty but must still be separated by a tab or comma. 空数据字段只是分配一个空字符串值。An empty data field just assigns an empty String value.

  • 终结点必须是唯一的,否则上传将失败。EndpointName must be unique, otherwise the upload fails. 如果存在重复的行或两行使用同一终结点,则冲突将导致不正确的联接。If there is a duplicate row or two rows that use the same EndpointName the conflict will cause incorrect joining.

  • EndpointLabel1、EndpointLabel2 和 EndpointLabel3 是可自定义的标签。EndpointLabel1, EndpointLabel2, and EndpointLabel3 are customizable labels. 它们可以是空字符串或值,如 "IT 部门指定的2018膝上型计算机" 或 "资产标签 5678"。They can be empty Strings or values such as “IT Department designated 2018 Laptop” or “Asset Tag 5678”.

  • 每行必须有六列,并且列必须按以下顺序排列:There must be six columns for each row and the columns must be in the following order:

    字段顺序:Field order:

    终结点、EndpointModel、EndpointType、EndpointLabel1、EndpointLabel2、EndpointLabel3EndpointName, EndpointModel, EndpointType, EndpointLabel1, EndpointLabel2, EndpointLabel3

    示例行:Sample row:

    1409W3534, Fabrikam Model 123, Laptop, IT designated 2018 Laptop, Asset Tag 5678, Purchase 2018,

更新生成文件Update a building file

在收集生成和子网信息时,管理员通常会在一段时间内将生成文件上载到多个迭代中,并在新子网可用时添加新的子网和生成信息。While gathering building and subnet information, administrators will often upload the building file in multiple iterations over time, adding new subnets and their building information as it becomes available. 出现这种情况时,你需要重新上载你的构建文件。When this occurs, you'll need to re-upload your building file. 此过程类似于上一节中所述的初始上载,还有一些例外,如下部分所述。This process is like the initial upload as described in the previous section, with a few exceptions as noted in the following section.

重要

一次只能有一个生成文件处于活动状态。Only one building file can be active at a time. 多个生成文件不具有累积性。Multiple building files aren't cumulative.

添加全新的子网Add net new subnets

有时,你需要将新的子网添加到 CQD 中的子网,而不是你的网络拓扑的一部分。There are times when you'll need to add net new subnets to CQD that weren't originally part of your network topology. 若要添加全新的子网,请在 CQD 中的 租户数据上传 页面执行以下操作:To add net new subnets, do the following from the Tenant Data Upload page in CQD:

  1. 如果尚未有最新的副本,请下载原始文件。Download the original file, if you don't already have an up-to-date copy.

  2. 删除 CQD 中的当前文件。Remove the current file in CQD.

  3. 编辑原始构建文件,并提供在获取网络新子网之前至少一天出现的结束日期。Edit the original building file and provide an end date that occurs at least one day before the net new subnets were acquired.

  4. 将新的全新子网附加到原始生成文件。Append the net new subnets to the original building file.

  5. 上载新修改的生成文件,并将开始日期设置为上一个生成文件结束后的一天。Upload the newly modified building file, and set the start date for one day after the previous building file ends.

添加缺少的子网Add missing subnets

在上载托管网络的生成信息后,每个托管网络都应具有一个建筑物关联。After you upload building information for managed networks, every managed network should have a building association. 但是,这并不总是这样。通常,缺少几个子网。However, this won't always be the case; typically, a few subnets are missed. 若要查找这些缺少的网络,请查看 CQD 中的 "体验质量报告" 页面上缺少的子网报告To find these missing networks, review the Missing Subnet Report on the Quality of Experience Reports page in CQD. 这将显示包含10个或更多音频流的所有子网,这些流在建筑物数据文件中未定义且标记为外部。This presents all the subnets with 10 or more audio streams that aren't defined in the building data file and are being marked as outside. 确保此列表中没有托管网络。Ensure that there are no managed networks in this list. 如果缺少子网,请使用以下过程更新原始生成数据文件,并将其重新上载到 CQD。If subnets are missing, use the following procedure to update the original building data file and re-upload it to CQD.

  1. 转到 CQD 中的 租户数据上传 页面。Go to the Tenant Data Upload page in CQD.

  2. 如果尚未有最新的副本,请下载原始文件。Download the original file, if you don't already have an up-to-date copy.

  3. 删除 CQD 中的当前文件。Remove the current file in CQD.

  4. 将新子网追加到原始文件。Append the new subnets to the original file.

  5. 上载构建文件。Upload the building file. 请务必先将开始日期设置为至少八个月,这样 CQD 将处理历史记录数据。Be sure to set the start date to at least eight months prior so that CQD will process historical data.

重要

你需要将租户 ID 作为 第二租户 id 的查询筛选器添加到此报表,以筛选报表以仅查看你的组织的租户数据。You'll need to add your tenant ID as a query filter for Second Tenant ID to this report to filter the report to view only your organization's tenant data. 否则,报表将显示联合子网。Otherwise, the report will show federated subnets.

备注

请确保将 "月" 报表筛选器调整为当前月份。Be sure to adjust the Month Year report filter to the current month. 选择 " 编辑",然后调整 " " 报表筛选器以保存新的默认月份。Select Edit, and adjust the Month Year report filter to save the new default month.

为 CQD 创建建筑地图Create a building map for CQD

改善和监控团队的通话质量Improve and monitor call quality for Teams

什么是 CQD?What is CQD?

设置通话质量仪表板 (CQD) Set up Call Quality Dashboard (CQD)

CQD 数据和报告CQD data and reports

使用 CQD 管理通话和会议质量Use CQD to manage call and meeting quality

CQD 中可用的维度和度量值Dimensions and measures available in CQD

CQD 中的流分类Stream Classification in CQD

使用 Power BI 分析 CQD 数据Use Power BI to analyze CQD data