Stay organized with collections
Save and categorize content based on your preferences.
This page explains how to view prebuilt Protected Resource reports in BigQuery.
The Backup and DR Service provides prebuilt Protected Resource reports
that are accessible in BigQuery. You can access these reports after you
execute the prebuilt script
in the same dataset
where the logs are being routed through the log sink.
The protected resource logs provide information about the number of applications
and virtual machines (VMs) protected in an appliance.
Last updated on: The timestamp when the protected resource information was last updated.
Resource name: The name of the resource.
Resource type: The type of resource, for example, Compute Engine
instance, Google Cloud VMware Engine, file system, or database.
Hostname: The hostname associated with the resource.
Backup plan policy template: The name of the backup template used to
protect the application.
Protected on: The date when the resource was protected.
Recovery point: The timestamp when the last successful backup was taken.
Protected data: The size of the protected data.
OnVault data: The size of data protected using OnVault pool.
Backup plan restrictions: The restrictions applied to a
backup plan. The restrictions can be scheduler disabled, expiration disabled,
snapshots disabled, streamsnap disabled, OnVault disabled, or process latest snapshot.
Backup inclusion or exclusion: The volumes or databases
that are included or excluded for virtual machines or database instances.
Policy overrides: The policy overrides that are set at the
backup template level.
Appliance name: The name of the appliance associated with the resource.
Remote appliance: The remote appliance where the backup is replicated.
Source appliance: The source appliance where the backup is taken.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eThis page explains how to access prebuilt Protected Resource reports within BigQuery, which are available after running a specific script in the designated dataset.\u003c/p\u003e\n"],["\u003cp\u003eThe Protected Resource reports detail the applications and virtual machines protected within an appliance, including information on resource name, type, and associated hostnames.\u003c/p\u003e\n"],["\u003cp\u003eThese reports also contain information about the backup process, such as the last updated timestamp, the recovery point, and the size of protected data, including information related to onVault.\u003c/p\u003e\n"],["\u003cp\u003eThe reports further include details on backup plan restrictions, policy overrides, and information on the source and remote appliances involved in the backup process.\u003c/p\u003e\n"]]],[],null,["# Protected Resource reports\n\nThis page explains how to view prebuilt Protected Resource reports in BigQuery.\n\nThe Backup and DR Service provides prebuilt Protected Resource reports\nthat are accessible in BigQuery. You can access these reports after you\n[execute the prebuilt script](/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery#sink)\nin the same [dataset](/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery#sink)\nwhere the logs are being routed through the log sink.\n\nThe protected resource logs provide information about the number of applications\nand virtual machines (VMs) protected in an appliance.\n\n- **Last updated on**: The timestamp when the protected resource information was last updated.\n- **Resource name**: The name of the resource.\n- **Resource type**: The type of resource, for example, Compute Engine instance, Google Cloud VMware Engine, file system, or database.\n- **Hostname**: The hostname associated with the resource.\n- **Backup plan policy template**: The name of the backup template used to protect the application.\n- **Protected on**: The date when the resource was protected.\n- **Recovery point**: The timestamp when the last successful backup was taken.\n- **Protected data**: The size of the protected data.\n- **OnVault data**: The size of data protected using OnVault pool.\n- **Backup plan restrictions** : The restrictions applied to a backup plan. The restrictions can be `scheduler disabled`, `expiration disabled`, `snapshots disabled`, `streamsnap disabled`, `OnVault disabled`, or `process latest snapshot`.\n- **Backup inclusion or exclusion**: The volumes or databases that are included or excluded for virtual machines or database instances.\n- **Policy overrides**: The policy overrides that are set at the backup template level.\n- **Appliance name**: The name of the appliance associated with the resource.\n- **Remote appliance**: The remote appliance where the backup is replicated.\n- **Source appliance**: The source appliance where the backup is taken.\n\nWhat's next\n-----------\n\n- Learn how to [Execute prebuilt reports script](/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery#script)\n- Learn how to [Write custom queries in BigQuery](/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery#custom-queries)\n- Learn how to [Download prebuilt reports](/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery#download)"]]
