Stay organized with collections
Save and categorize content based on your preferences.
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.
[[["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-07 UTC."],[[["\u003cp\u003ePrebuilt Unprotected Resource reports are available in BigQuery through the Backup and DR Service.\u003c/p\u003e\n"],["\u003cp\u003eThese reports detail unprotected resources across backup/recovery appliances and are accessible after running a specific script in the log sink's dataset.\u003c/p\u003e\n"],["\u003cp\u003eThe reports include information such as Appliance ID, Last Updated On, Discovered On, and various resource-specific details like Host ID, Instance name, Resource ID, and Resource type.\u003c/p\u003e\n"],["\u003cp\u003eThe provided document can further explain how to execute the prebuilt reports script, write custom queries, and view prebuilt reports in other sources.\u003c/p\u003e\n"]]],[],null,[]]
