配置 Azure 备份报表Configure Azure Backup reports

备份管理员的一个常见需求是根据时间跨度较长的数据获取有关备份的见解。A common requirement for backup admins is to obtain insights on backups based on data that spans a long period of time. 此类解决方案的用例包括:Use cases for such a solution include:

  • 分配和预测需使用的云存储空间。Allocating and forecasting of cloud storage consumed.
  • 审核备份和还原。Auditing of backups and restores.
  • 确定不同粒度级别的关键趋势。Identifying key trends at different levels of granularity.

如今,Azure 备份提供了一种使用 Azure Monitor 日志Azure 工作簿的报表解决方案。Today, Azure Backup provides a reporting solution that uses Azure Monitor logs and Azure workbooks. 这些资源有助于你跨整个备份资产获得有关备份的丰富见解。These resources help you get rich insights on your backups across your entire backup estate. 本文介绍如何配置和查看 Azure 备份报表。This article explains how to configure and view Azure Backup reports.

支持的方案Supported scenarios

  • Azure VM、Azure VM 中的 SQL、Azure VM 中的 SAP HANA、Azure 恢复服务 (MARS) 代理、Azure 备份服务器 (MABS) 和 System Center Data Protection Manager (DPM) 支持备份报表。Backup reports are supported for Azure VMs, SQL in Azure VMs, SAP HANA in Azure VMs, Azure Recovery Services (MARS) agent, Azure Backup Server (MABS), and System Center Data Protection Manager (DPM).
  • 对于 DPM 工作负载,DPM 版本 5.1.363.0 及更高版本和代理版本 2.0.9127.0 及更高版本支持备份报表。For DPM workloads, Backup reports are supported for DPM Version 5.1.363.0 and above and Agent Version 2.0.9127.0 and above.
  • 对于 MABS 工作负载,MABS 版本 13.0.415.0 及更高版本和代理版本 2.0.9170.0 及更高版本支持备份报表。For MABS workloads, Backup reports are supported for MABS Version 13.0.415.0 and above and Agent Version 2.0.9170.0 and above.
  • 只要将备份报告的数据发送到用户有权访问的 Log Analytics 工作区,就可以在所有备份项目、保管库、订阅和区域中查看备份报表。Backup reports can be viewed across all backup items, vaults, subscriptions, and regions as long as their data is being sent to a Log Analytics workspace that the user has access to. 若要查看一组保管库的报表,只需具有对 Log Analytics 工作区(保管库将数据发送到该工作区)的读取访问权限。To view reports for a set of vaults, you only need to have reader access to the Log Analytics workspace to which the vaults are sending their data. 无需具有对单个保管库的访问权限。You don't need to have access to the individual vaults.
  • 目前可以在备份报表中查看最多 100 个 Log Analytics 工作区(跨租户)的数据。Currently, data can be viewed in Backup Reports across a maximum of 100 Log Analytics Workspaces (across tenants).
  • 报表中目前不显示日志备份作业的数据。Data for log backup jobs currently isn't displayed in the reports.

入门Get started

请遵循以下步骤开始使用报表。Follow these steps to start using the reports.

1.创建 Log Analytics 工作区或使用现有工作区1. Create a Log Analytics workspace or use an existing one

设置一个或多个 Log Analytics 工作区来存储备份报表数据。Set up one or more Log Analytics workspaces to store your Backup reporting data. 可以创建此 Log Analytics 工作区的位置和订阅与保管库所处的位置和订阅无关。The location and subscription where this Log Analytics workspace can be created is independent of the location and subscription where your vaults exist.

若要设置 Log Analytics 工作区,请参阅在 Azure 门户中创建 Log Analytics 工作区To set up a Log Analytics workspace, see Create a Log Analytics workspace in the Azure portal.

默认情况下,Log Analytics 工作区中的数据将保留 30 天。By default, the data in a Log Analytics workspace is retained for 30 days. 若要查看更长时间范围的数据,请更改 Log Analytics 工作区的保持期。To see data for a longer time horizon, change the retention period of the Log Analytics workspace. 若要更改保持期,请参阅通过 Azure Monitor 日志管理使用情况和成本To change the retention period, see Manage usage and costs with Azure Monitor logs.

2.为保管库配置诊断设置2. Configure diagnostics settings for your vaults

恢复服务保管库等 Azure 资源管理器资源会记录有关计划的操作和用户触发的操作的信息作为诊断数据。Azure Resource Manager resources, such as Recovery Services vaults, record information about scheduled operations and user-triggered operations as diagnostics data.

在“恢复服务保管库”的“监视”部分,选择“诊断设置”并指定恢复服务保管库的诊断数据的目标。In the monitoring section of your Recovery Services vault, select Diagnostics settings and specify the target for the Recovery Services vault's diagnostic data. 若要了解有关使用诊断事件的详细信息,请参阅对恢复服务保管库使用诊断设置To learn more about using diagnostic events, see Use diagnostics settings for Recovery Services vaults.

诊断设置窗格

Azure 备份还提供内置 Azure Policy 定义,该定义会自动配置给定范围内的所有保管库的诊断设置。Azure Backup also provides a built-in Azure Policy definition, which automates the configuration of diagnostics settings for all vaults in a given scope. 若要了解如何使用此策略,请参阅大规模配置保管库诊断设置To learn how to use this policy, see Configure vault diagnostics settings at scale.

备注

配置诊断后,可能需要 24 小时才能完成初始数据推送。After you configure diagnostics, it might take up to 24 hours for the initial data push to complete. 数据开始流入 Log Analytics 工作区后,可能无法立即在报表中看到数据,因为报表中不显示当前未满一天的数据。After data starts flowing into the Log Analytics workspace, you might not see data in the reports immediately because data for the current partial day isn't shown in the reports. 有关详细信息,请参阅备份报表中使用的约定For more information, see Conventions used in Backup reports. 建议在将保管库配置为将数据发送到 Log Analytics 的两天后开始查看报表。We recommend that you start viewing the reports two days after you configure your vaults to send data to Log Analytics.

3.在 Azure 门户中查看报表3. View reports in the Azure portal

将保管库配置为将数据发送到 Log Analytics 后,请转到任何保管库的窗格并选择“备份报表”来查看备份报表。After you've configured your vaults to send data to Log Analytics, view your Backup reports by going to any vault's pane and selecting Backup Reports.

保管库仪表板

选择此链接可打开备份报表工作簿。Select this link to open up the Backup report workbook.

备注

  • 目前,报表的初始加载可能需要 1 分钟。Currently, the initial load of the report might take up to 1 minute.
  • 恢复服务保管库仅仅是备份报表的入口点。The Recovery Services vault is merely an entry point for Backup reports. 从保管库的窗格打开备份报表工作簿后,请选择适当的 Log Analytics 工作区集以查看跨所有保管库聚合的数据。After the Backup report workbook opens up from a vault's pane, select the appropriate set of Log Analytics workspaces to see data aggregated across all your vaults.

报表包含各种选项卡:The report contains various tabs:

总结Summary

使用此选项卡可获取备份资产的简要概述。Use this tab to get a high-level overview of your backup estate. 你可以快速查看备份项的总数、使用的云存储空间总量、受保护实例的数量以及每种工作负载类型的作业成功率。You can get a quick glance of the total number of backup items, total cloud storage consumed, the number of protected instances, and the job success rate per workload type. 有关特定备份项目类型的详细信息,请转到相应的选项卡。For more detailed information about a specific backup artifact type, go to the respective tabs.

“摘要”选项卡

备份项Backup Items

使用此选项卡能够以备份项级别查看使用的云存储空间的信息和趋势。Use this tab to see information and trends on cloud storage consumed at a Backup-item level. 例如,如果在 Azure VM 备份中使用 SQL,则可以看到正在备份的每个 SQL 数据库所使用的云存储空间。For example, if you use SQL in an Azure VM backup, you can see the cloud storage consumed for each SQL database that's being backed up. 你还可以选择查看特定保护状态的备份项的数据。You can also choose to see data for backup items of a particular protection status. 例如,选择选项卡顶部的“保护已停止”磁贴将对下面的小组件进行筛选,只显示处于“保护已停止”状态的备份项的数据。For example, selecting the Protection Stopped tile at the top of the tab filters all the widgets underneath to show data only for Backup items in the Protection Stopped state.

“备份项”选项卡

使用情况Usage

使用此选项卡可以查看备份的关键计费参数。Use this tab to view key billing parameters for your backups. 此选项卡上显示的信息可归于计费实体(受保护容器)级别。The information shown on this tab is at a billing entity (protected container) level. 例如,在将 DPM 服务器备份到 Azure 的情况下,你可以查看 DPM 服务器使用的受保护实例和云存储的趋势。For example, if a DPM server is being backed up to Azure, you can view the trend of protected instances and cloud storage consumed for the DPM server. 同样,如果在 Azure 备份中使用 SQL,或者在 Azure 备份中使用 SAP HANA,此选项卡将在包含这些数据库的虚拟机级别上提供与使用情况相关的信息。Similarly, if you use SQL in Azure Backup or SAP HANA in Azure Backup, this tab gives you usage-related information at the level of the virtual machine in which these databases are contained.

“使用情况”选项卡

备注

对于 DPM 工作负荷,用户可能会发现报表中显示的使用情况值与恢复服务保管库“概览”选项卡中显示的聚合使用情况值之间存在细微差异(每个 DPM 服务器相差大约 20 MB)。出现这种差异的原因在于,每个要注册备份的 DPM 服务器都有一个关联的“元数据”数据源,该数据源未作为报告项目显示。For DPM workloads, users might see a slight difference (of the order of 20 MB per DPM server) between the usage values shown in the reports as compared to the aggregate usage value as shown in the Recovery Services vault Overview tab. This difference is accounted for by the fact that every DPM server being registered for backup has an associated 'metadata' datasource which isn't surfaced as an artifact for reporting.

作业Jobs

使用此选项卡可以查看作业的长时间运行趋势,例如每天失败的作业数和作业失败的主要原因。Use this tab to view long-running trends on jobs, such as the number of failed jobs per day and the top causes of job failure. 你可以在聚合级别和备份项级别查看此信息。You can view this information at both an aggregate level and at a Backup-item level. 选择网格中的特定备份项,即可查看在选定时间范围内该备份项上触发的每个作业的详细信息。Select a particular Backup item in a grid to view detailed information on each job that was triggered on that Backup item in the selected time range.

“作业”选项卡

策略Policies

使用此选项卡可以查看有关所有活动策略的信息,例如关联项的数量,以及按照给定策略备份的项所使用的云存储空间总量。Use this tab to view information on all of your active policies, such as the number of associated items and the total cloud storage consumed by items backed up under a given policy. 选择特定策略以查看与其关联的每个备份项的信息。Select a particular policy to view information on each of its associated Backup items.

“策略”选项卡

优化Optimize

使用此选项卡可查看备份的潜在成本优化机会。Use this tab to gain visibility into potential cost-optimization opportunities for your backups. 下面是“优化”选项卡当前提供见解的方案:Following are the scenarios for which the Optimize tab currently provides insights:

非活动资源Inactive Resources

使用此视图,可识别在很长一段时间内未成功备份的那些备份项。Using this view, you can identify those backup items that haven't had a successful backup for a significant duration of time. 这可能意味着所备份的底层计算机不再存在(因此导致备份失败),或者该计算机存在某些问题,导致备份不能可靠地进行。This could either mean that the underlying machine that's being backed up doesn't exist anymore (and so is resulting in failed backups), or there's some issue with the machine that's preventing backups from being taken reliably.

若要查看非活动资源,请导航到“优化”选项卡,然后选择“非活动资源”磁贴。To view inactive resources, navigate to the Optimize tab, and select the Inactive Resources tile. 选择此磁贴会显示一个网格,其中包含所选范围内存在的所有非活动资源的详细信息。Select this tile displays a grid that contains details of all the inactive resources that exist in the selected scope. 默认情况下,此网格会显示过去 7 天内没有恢复点的项。By default, the grid shows items that don't have a recovery point in the last seven days. 若要查找不同时间范围内的非活动资源,可以调整选项卡顶部的“时间范围”筛选器。To find inactive resources for a different time range, you can adjust the Time Range filter at the top of the tab.

确定非活动资源后,可以通过导航到该资源的备份项仪表板或 Azure 资源窗格(如果适用)来进一步调查该问题。Once you've identified an inactive resource, you can investigate the issue further by navigating to the backup item dashboard or the Azure resource pane for that resource (wherever applicable). 根据情况,你可以选择停止计算机的备份(如果该计算机不再存在)并删除不必要的备份(这可节省费用),也可以修复计算机中的问题,以确保备份可靠地进行。Depending on your scenario, you can choose to either stop backup for the machine (if it doesn't exist anymore) and delete unnecessary backups, which saves costs, or you can fix issues in the machine to ensure that backups are taken reliably.

“优化”选项卡 - 非活动资源

保留期较长的备份项Backup Items with a large retention duration

使用此视图,可以识别其备份保留时间长于组织所需时间的项目。Using this view, you can identify those items that have backups retained for a longer duration than required by your organization.

在选择“策略优化”磁贴后选择“保留期优化”磁贴会显示一个网格,其中包含每日、每周、每月或每年保留点 (RP) 的保留期大于指定值的所有备份项。Selecting the Policy Optimizations tile followed by the Retention Optimizations tile displays a grid containing all backup items for which the retention of either the daily, weekly, monthly, or yearly retention point (RP) is greater than a specified value. 默认情况下,该网格会显示所选范围内的所有备份项。By default, the grid displays all backup items in the selected scope. 可以对每日、每周、每月和每年的 RP 保留期使用筛选器来进一步筛选网格,确定哪些项目的保留期可能会减少,从而节省备份存储成本。You can use the filters for daily, weekly, monthly, and yearly RP retention to filter the grid further and identify those items for which retention could potentially be reduced to save on backup storage costs.

对于 SQL 和 SAP HANA 等数据库工作负荷,网格中显示的保留期对应于完整备份点的保留期,而不是差异备份点的保留期。For database workloads like SQL and SAP HANA, the retention periods shown in the grid correspond to the retention periods of the full backup points and not the differential backup points. 这同样适用于保留期筛选器。The same applies for the retention filters as well.

“优化”选项卡 - 保留期优化

针对每日完整备份配置的数据库Databases configured for daily full backup

使用此视图,可以识别已配置为每日进行完整备份的数据库工作负荷。Using this view, you can identify database workloads that have been configured for daily full backup. 通常,将每日差异备份与每周完整备份结合使用更为经济高效。Often, using daily differential backup along with weekly full backup is more cost-effective.

在选择“策略优化”磁贴后选择“备份计划优化”磁贴会显示一个网格,其中包含使用每日完整备份策略的所有数据库。Selecting the Policy Optimizations tile followed by the Backup Schedule Optimizations tile displays a grid containing all databases with a daily full backup policy. 可以选择导航到特定备份项并修改策略,以便将每日差异备份和每周完整备份结合使用。You can choose to navigate to a particular backup item and modify the policy to use daily differential backup with weekly full backup.

选项卡顶部的“备份管理类型”筛选器应已选择“Azure VM 中的 SQL”和“Azure VM 中的 SAP HANA”项,以便网格能够按预期显示数据库工作负荷。The Backup Management Type filter at the top of the tab should have the items SQL in Azure VM and SAP HANA in Azure VM selected, for the grid to be able to display database workloads as expected.

“优化”选项卡 - 备份计划优化

导出到 ExcelExport to Excel

选择任何小组件(如表或图表)右上角的向下箭头按钮,并在应用了现有筛选器的情况下,将该小组件的内容按原样导出为 Excel 工作表。Select the down arrow button in the upper right of any widget, like a table or chart, to export the contents of that widget as an Excel sheet as-is with existing filters applied. 若要将表的更多行导出到 Excel,可以使用每个网格顶部的“每页行数”下拉箭头来增加页面上显示的行数。To export more rows of a table to Excel, you can increase the number of rows displayed on the page by using the Rows Per Page drop-down arrow at the top of each grid.

固定到仪表板Pin to dashboard

选择每个小组件顶部的固定按钮,将小组件固定到 Azure 门户仪表板。Select the pin button at the top of each widget to pin the widget to your Azure portal dashboard. 此功能可帮助你创建自定义的仪表板,以便显示所需的最重要信息。This feature helps you create customized dashboards tailored to display the most important information that you need.

备份报表中使用的约定Conventions used in Backup reports

  • 筛选器在每个选项卡上从左到右、从上到下工作。也就是说,任何筛选器都只应用于位于筛选器右侧或筛选器下方的所有小组件。Filters work from left to right and top to bottom on each tab. That is, any filter only applies to all those widgets that are positioned either to the right of that filter or below that filter.
  • 选择彩色磁贴将筛选磁贴下面的小组件,仅显示与该磁贴的值相关的记录。Selecting a colored tile filters the widgets below the tile for records that pertain to the value of that tile. 例如,选择备份项选项卡上的“保护已停止”磁贴将筛选下面的网格和图表,以显示处于“保护已停止”状态的备份项的数据 。For example, selecting the Protection Stopped tile on the Backup Items tab filters the grids and charts below to show data for backup items in the Protection Stopped state.
  • 无法选择未着色的磁贴。Tiles that aren't colored aren't selectable.
  • 报表中不显示当前未满一天的数据。Data for the current partial day isn't shown in the reports. 因此,当选定的“时间范围”值为“过去 7 天”时,报告将显示过去完整的 7 天内的记录 。So, when the selected value of Time Range is Last 7 days, the report shows records for the last seven completed days. 当前日期不包括在内。The current day isn't included.
  • 报表显示在选定的时间范围内触发的作业(日志作业除外)的详细信息。The report shows details of jobs (apart from log jobs) that were triggered in the selected time range.
  • 显示的“云存储空间”和“受保护的实例”的值为选定时间范围结束时的值 。The values shown for Cloud Storage and Protected Instances are at the end of the selected time range.
  • 报表中显示的备份项为选定时间范围结束时的项。The Backup items displayed in the reports are those items that exist at the end of the selected time range. 不会显示在选定时间范围中间删除的备份项。Backup items that were deleted in the middle of the selected time range aren't displayed. 同样的约定也适用于备份策略。The same convention applies for Backup policies as well.

查询加载时间Query load times

备份报表中的小组件由 Kusto 查询提供支持,该查询在用户的 Log Analytics 工作区上运行。The widgets in the Backup report are powered by Kusto queries, which run on the user's Log Analytics workspaces. 这些查询通常涉及处理大量数据,它们使用多个连接来获得更丰富的见解。These queries typically involve the processing of large amounts of data, with multiple joins to enable richer insights. 因此,当用户跨大型备份资产查看报表时,小组件可能不会立即加载。As a result, the widgets might not load instantaneously when the user views reports across a large backup estate. 此表根据备份项的数量和查看报表的时间范围,粗略估计了加载不同的小组件所需的时间。This table provides a rough estimate of the time that different widgets can take to load, based on the number of Backup items and the time range for which the report is being viewed.

数据源数量# Data sources 时间范围Time horizon 大致加载时间Approximate load times
~5 K~5 K 1 个月1 month 磁贴:5-10 秒Tiles: 5-10 secs
网格:5-10 秒Grids: 5-10 secs
图表:5-10 秒Charts: 5-10 secs
报表级筛选器:5-10 秒Report-level filters: 5-10 secs
~5 K~5 K 3 个月3 months 磁贴:5-10 秒Tiles: 5-10 secs
网格:5-10 秒Grids: 5-10 secs
图表:5-10 秒Charts: 5-10 secs
报表级筛选器:5-10 秒Report-level filters: 5-10 secs
~10 K~10 K 3 个月3 months 磁贴:15-20 秒Tiles: 15-20 secs
网格:15-20 秒Grids: 15-20 secs
图表:1-2 分钟Charts: 1-2 mins
报表级筛选器:25-30 秒Report-level filters: 25-30 secs
~15 K~15 K 1 个月1 month 磁贴:15-20 秒Tiles: 15-20 secs
网格:15-20 秒Grids: 15-20 secs
图表:50-60 秒Charts: 50-60 secs
报表级筛选器:20-25 秒Report-level filters: 20-25 secs
~15 K~15 K 3 个月3 months 磁贴:20-30 秒Tiles: 20-30 secs
网格:20-30 秒Grids: 20-30 secs
图表:2-3 分钟Charts: 2-3 mins
报表级筛选器:50-60 秒Report-level filters: 50-60 secs

Power BI 报表有哪些变化?What happened to the Power BI reports?

  • 早期用于报表的 Power BI 模板应用(从 Azure 存储帐户中获取数据)即将弃用。The earlier Power BI template app for reporting, which sourced data from an Azure storage account, is on a deprecation path. 我们建议开始将保管库诊断数据发送到 Log Analytics 以查看报表。We recommend that you start sending vault diagnostic data to Log Analytics to view reports.

  • 此外,将诊断数据发送到存储帐户或 LA 工作区的 V1 架构也即将弃用。In addition, the V1 schema of sending diagnostics data to a storage account or an LA Workspace is also on a deprecation path. 这意味着,如果基于 V1 架构编写了任何自定义查询或自动化,则建议更新这些查询以使用当前支持的 V2 架构。This means that if you've written any custom queries or automations based on the V1 schema, you're advised to update these queries to use the currently supported V2 schema.

后续步骤Next steps

详了解与 Azure 备份相关的监视和报表Learn more about monitoring and reporting with Azure Backup