This page provides an overview of prebuilt backup and restore job reports, which are available in BigQuery and Looker Studio. These reports are displayed for vaulted resources that are protected using backup plans.
You can access these reports after you execute the prebuilt script in the same project where the logs are being routed through the log sink.
Backup job details report
The backup job details report provides a summary of the backup jobs and includes the following fields.
- job_name: The name of the backup job.
- resource_name: The name of the protected resource.
- resource_project_name: The project name of the resource.
- job_status: The status of the job, which can be
SUCCESSFUL
,FAILED
,RUNNING
, orSKIPPED
. - error_type: The description of the error type. For example,
PERMISSION_DENIED
. The error type is displayed asNull
if no error occurred for the job. - error_code: The error code associated for the failed job. The error code
is displayed as
Null
if no error occurred for the job. - error_message: The error message for the failed job. The error message is
displayed as
Null
if no error occurred for the job. - job_start_time: The start time of the job, which is in the
YYYY-MM-DD HH:MM:SS.SSS UTC
format. - job_end_time: The end time of the job, which is in the
YYYY-MM-DD HH:MM:SS.SSS UTC
format. - duration: The duration taken to complete the backup job.
- incremental_backup_size_in_gib: The amount of incremental backup data copied in GiB.
- backup_consistency_time: The timestamp when the backup was successfully
taken, which is in the
YYYY-MM-DDTHH:MM:SS.SSSZ
format. - backup_plan_name: The name of the backup plan that is associated to backup the resource.
- backup_rule: The name of the backup rule that triggered the backup job.
- backup_vault_name: The name of the backup vault where the backups are stored.
- backup_vault_project_name: The name of the backup vault project where the backups are stored.
- resource_location: The location of the protected resource.
- resource_type: The type of resource. For example, a Compute Engine instance.
- resource_id: The resource ID associated with a job.
- job_category: The category of job, which can be
SCHEDULED_BACKUP
,ON_DEMAND_BACKUP
, orRESTORE
. - job_id: The ID associated with the backup job.
Backup jobs summary
The backup jobs summary report provides a daily summary of backup jobs and includes the following fields.
- date: The backup job date, which is in YYYY-MM-DD format.
- resource_project_name: The project name of the resource.
- job_category: The category of job, which can be
SCHEDULED_BACKUP
orON_DEMAND_BACKUP
. - success_percent: The percentage of backup jobs that are successful.
- total: The total number of backup jobs that ran.
- successful: The total number of backup jobs succeeded.
- failed: The total number of backup jobs failed.
- skipped: The total number of backup jobs skipped.
Successful backup jobs report
The successful backup jobs report includes the following fields.
- job_name: The name of the backup job.
- resource_name: The name of the protected resource.
- resource_project_name: The project name of the resource.
- job_start_time: The start time of the job, which is
in the
YYYY-MM-DD HH:MM:SS.SSS UTC
format. - job_end_time: The end time of the job, which is in the
YYYY-MM-DD HH:MM:SS.SSS UTC
format. - duration: The duration taken to complete the backup job.
- incremental_backup_size_in_gib: The amount of incremental backup data copied in GiB.
- backup_consistency_time: The timestamp when the backup was successfully
taken, which is in the
YYYY-MM-DDTHH:MM:SS.SSSZ
format. - backup_plan_name: The name of the backup plan that is associated to backup the resource.
- backup_rule: The name of the backup rule that triggered the backup job.
- backup_vault_name: The name of the backup vault where the backups are stored.
- backup_vault_project_name: The name of the backup vault project where the backups are stored.
- resource_type: The type of resource. For example, a Compute Engine instance.
- resource_id: The resource ID associated with a job.
- job_category: The category of job, which can be
SCHEDULED_BACKUP
,ON_DEMAND_BACKUP
, orRESTORE
. - job_id: The ID associated with the job.
Failed backup jobs report
The failed backup jobs report includes the following fields.
- job_name: The name of the backup job.
- resource_name: The name of the protected resource.
- resource_project_name: The project name of the resource.
- error_type: The description of the error type. For example,
PERMISSION_DENIED
. The error type is displayed asNull
if no error occurred for the job. - error_code: The error code associated for the failed job. The error code
is displayed as
Null
if no error occurred for the job. - error_message: The error message for the failed job. The error message is
displayed as
Null
if no error occurred for the job. - job_start_time: The start time of the job, which is in the
YYYY-MM-DD HH:MM:SS.SSS UTC
format. - job_end_time: The end time of the job, which is in the
YYYY-MM-DD HH:MM:SS.SSS UTC
format. - duration: The duration taken to complete the backup job.
- backup_plan_name: The name of the backup plan that is associated to backup the resource.
- backup_rule: The name of the backup rule that triggered the backup job.
- backup_vault_name: The name of the backup vault where the backups are stored.
- backup_vault_project_name: The name of the backup vault project where the backups are stored.
- resource_type: The type of resource. For example, a Compute Engine instance.
- resource_id: The resource ID associated with a job.
- job_category: The category of job, which can be
SCHEDULED_BACKUP
,ON_DEMAND_BACKUP
, orRESTORE
. - job_id: The ID associated with the job.
Skipped backup jobs report
The skipped backup jobs report includes details of the skipped backup jobs and the following fields. Backup jobs might skip to backup when the backup fails to start within the backup window.
- job_name: The name of the backup job.
- resource_name: The name of the protected resource.
- resource_project_name: The project name of the resource.
- backup_plan_name: The name of the backup plan that is associated to backup the resource.
- backup_rule: The name of the backup rule that triggered the backup job.
- backup_vault_name: The name of the backup vault where the backups are stored.
- job_start_time: The start time of the job, which is
in the
YYYY-MM-DD HH:MM:SS.SSS UTC
format. - backup_vault_project_name: The name of the backup vault project where the backups are stored.
- resource_type: The type of resource. For example, a Compute Engine instance.
- resource_id: The resource ID associated with a job.
- job_category: The category of job, which can be
SCHEDULED_BACKUP
,ON_DEMAND_BACKUP
, orRESTORE
. - job_id: The ID associated with the job.
Restore jobs summary
The restore jobs summary report provides a daily summary of restore jobs and includes the following fields.
- date: The restore job date, which is in YYYY-MM-DD format.
- restore_project_name: The project name where the resources are restored.
- backup_vault_project_name: The name of the backup vault project from where the restores are triggered.
- success_percent: The percentage of restored jobs that are successful.
- total: The total number of restored jobs that ran.
- successful: The total number of restored jobs succeeded.
- failed: The total number of restored jobs failed.
Restore job details
The restore job details report includes the following fields.
- job_name: The name of the job.
- resource_name: The name of the resource that is associated with the restore job.
- resource_project_name: The project name where the resources are restored.
- job_status: The status of the job, which can be
SUCCESSFUL
,FAILED
, orRUNNING
. - error_type: The description of the error type. For example,
PERMISSION_DENIED
. The error type is displayed asNull
if no error occurred for the job. - error_code: The error code associated for the failed restore job. The
error code is displayed as
Null
if no error occurred for the job. - error_message: The error message for the failed restore job. The error
message is displayed as
Null
if no error occurred for the job. - job_start_time: The start time of the restore job, which is in the
YYYY-MM-DD HH:MM:SS.SSS UTC
format. - job_end_time: The end time of the restore job, which is in the
YYYY-MM-DD HH:MM:SS.SSS UTC
format. - duration: The duration taken to complete the restore job.
- restore_resource_name: The name of the resource that is being restored.
- restore_project_name: The name of the project where the backups are being restored.
- backup_vault_name: The name of the backup vault where the backup of the resource is stored.
- backup_vault_project_name: The name of the backup vault project from where restores are triggered.
- resource_location: The location of the protected resource.
- resource_type: The type of resource. For example, a Compute Engine instance.
- resource_id: The resource ID associated with a job.
- job_id: The ID associated with the job.
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