Stay organized with collections
Save and categorize content based on your preferences.
This page provides an overview of prebuilt Daily Schedule Compliance in BigQuery.
The Backup and DR Service provides prebuilt Daily Schedule Compliance reports
that are accessible in BigQuery. You can access these reports after
executing the prebuilt script
in the same dataset
where the logs are being routed through the log sink. These reports display the
data for the last seven days by default.
The Daily Schedule Compliance report provides information about the compliance
status of daily schedule backup policies for your resources.
Resource name: The name of the resource associated with the daily schedule backup policy.
Resource type: The type of resource, for example, Compute Engine instance, Google Cloud VMware Engine, or a database.
Backup rule policy name: The backup policy name that the compliance has reporting for.
Backup plan policy template: The name of the template that the daily schedule backup policy is part of.
Date: The date that the compliance status is reported on.
Backup window start time: The start time of the daily schedule backup policy window.
Job type: The daily schedule backup policy job type. It can be snapshot, OnVault, streamsnap, restore, or direct to OnVault.
Status: The compliance status of the daily schedule backup policy. The status can be success, failure, unknown, or blank.
Comment: A description explaining the compliance status of the daily schedule backup policy.
Appliance name: The name of the appliance associated with the daily schedule backup policy.
Hostname: The hostname associated with the daily d backup policy.
[[["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-09-03 UTC."],[[["\u003cp\u003ePrebuilt Daily Schedule Compliance reports are available in BigQuery through the Backup and DR Service.\u003c/p\u003e\n"],["\u003cp\u003eThese reports detail the compliance status of daily schedule backup policies for resources and are accessible in the same dataset where logs are routed after executing a prebuilt script.\u003c/p\u003e\n"],["\u003cp\u003eThe reports present data for the last seven days, including details such as resource name, type, backup policy names, dates, job type, compliance status, and associated comments.\u003c/p\u003e\n"],["\u003cp\u003eThe reports provide details on the job type, which can be snapshot, OnVault, streamsnap, restore, or direct to OnVault.\u003c/p\u003e\n"]]],[],null,["# Daily Schedule Compliance reports\n\nThis page provides an overview of prebuilt Daily Schedule Compliance in BigQuery.\n\nThe Backup and DR Service provides prebuilt Daily Schedule Compliance reports\nthat are accessible in BigQuery. You can access these reports after\n[executing 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. These reports display the\ndata for the last seven days by default.\n\nThe Daily Schedule Compliance report provides information about the compliance\nstatus of daily schedule backup policies for your resources.\n\n- **Resource name**: The name of the resource associated with the daily schedule backup policy.\n- **Resource type**: The type of resource, for example, Compute Engine instance, Google Cloud VMware Engine, or a database.\n- **Backup rule policy name**: The backup policy name that the compliance has reporting for.\n- **Backup plan policy template**: The name of the template that the daily schedule backup policy is part of.\n- **Date**: The date that the compliance status is reported on.\n- **Backup window start time**: The start time of the daily schedule backup policy window.\n- **Job type**: The daily schedule backup policy job type. It can be snapshot, OnVault, streamsnap, restore, or direct to OnVault.\n- **Status**: The compliance status of the daily schedule backup policy. The status can be success, failure, unknown, or blank.\n- **Comment**: A description explaining the compliance status of the daily schedule backup policy.\n- **Appliance name**: The name of the appliance associated with the daily schedule backup policy.\n- **Hostname**: The hostname associated with the daily d backup policy.\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/custom-query)\n- Learn how to [Download prebuilt reports](/backup-disaster-recovery/docs/monitor-reports/logs-route-bigquery#download)"]]
