This page explains how to view prebuilt Unprotected Resource reports in BigQuery.
The Backup and DR Service provides prebuilt Unprotected 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 unprotected resource reports provide information about unprotected resources across backup/recovery appliances.
- Appliance ID: The ID of the appliance on which the resource is discovered.
- Last updated On: The timestamp when the unprotected resource information was last updated.
- Discovered on: The date when the resource was first discovered.
- Discovered by: The name of the appliance on which the resource is discovered.
- Host ID: The host ID associated with the resource.
- Host name: The hostname associated with the resource.
- Instance name: The name of the database instance. If the resource is not of the database type, it shows N/A.
- Resource ID: The ID of the resource.
- 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.
What's next
- Learn how to Execute prebuilt reports script
- Learn how to Write custom queries in BigQuery
- Learn how to View prebuilt reports in Connected Sheets
- Learn how to View prebuilt reports in Looker Studio
- Learn how to Download prebuilt reports