Table: azure_data_protection_backup_job - Query Azure Data Protection Backup Jobs using SQL

Azure Data Protection Backup Jobs enable organizations to manage and monitor the backup processes for various data sources. These jobs provide detailed information about the backup instances, job statuses, errors, and performance metrics, which are essential for ensuring data integrity and recovery.

Table Usage Guide

The azure_data_protection_backup_job table provides insights into backup jobs within Microsoft Azure. As an IT Administrator or Data Protection Officer, you can explore details about each backup job, including its status, duration, errors, and associated resources. Use this table to ensure your backup processes are functioning correctly and to quickly identify and resolve any issues.

Examples

Basic info

Explore the status and details of your Azure Data Protection Backup Jobs to understand their current state and type. This is beneficial for auditing and managing your backup processes effectively.

select
  name,
  id,
  operation,
  operation_category,
  status,
  start_time,
  end_time
from
  azure_data_protection_backup_job;

select
  name,
  id,
  operation,
  operation_category,
  status,
  start_time,
  end_time
from
  azure_data_protection_backup_job;

List backup jobs with errors

Identify backup jobs that have encountered errors. This helps in troubleshooting and resolving issues to ensure data protection continuity.

select
  name,
  id,
  status,
  jsonb_array_elements_text(error_details) as error_detail
from
  azure_data_protection_backup_job
where
  status = 'Failed';

select
  name,
  id,
  status,
  json_each_text(error_details) as error_detail
from
  azure_data_protection_backup_job
where
  status = 'Failed';

List user-triggered backup jobs

Explore the backup jobs that were triggered manually by users. This helps in understanding the frequency and context of adhoc backups.

select
  name,
  id,
  is_user_triggered,
  start_time,
  end_time
from
  azure_data_protection_backup_job
where
  is_user_triggered = true;

select
  name,
  id,
  is_user_triggered,
  start_time,
  end_time
from
  azure_data_protection_backup_job
where
  is_user_triggered = true;

List backup jobs by policy

Get an overview of backup jobs associated with specific policies. This can assist in ensuring compliance with data protection policies and understanding the effectiveness of different backup strategies.

select
  name,
  id,
  policy_name,
  start_time,
  end_time,
  status
from
  azure_data_protection_backup_job
where
  policy_name = 'your_policy_name';

select
  name,
  id,
  policy_name,
  start_time,
  end_time,
  status
from
  azure_data_protection_backup_job
where
  policy_name = 'your_policy_name';

List backup jobs by data source

Explore backup jobs based on their data sources. This helps in understanding the backup coverage and identifying any gaps in data protection.

select
  name,
  id,
  data_source_name,
  data_source_type,
  start_time,
  end_time,
  status
from
  azure_data_protection_backup_job
where
  data_source_name = 'your_data_source_name';

select
  name,
  id,
  data_source_name,
  data_source_type,
  start_time,
  end_time,
  status
from
  azure_data_protection_backup_job
where
  data_source_name = 'your_data_source_name';

List backup jobs by region

Get a regional overview of your backup jobs to ensure that all geographical locations are adequately covered and to identify any regional issues.

select
  name,
  id,
  region,
  start_time,
  end_time,
  status
from
  azure_data_protection_backup_job
where
  region = 'your_region';

select
  name,
  id,
  region,
  start_time,
  end_time,
  status
from
  azure_data_protection_backup_job
where
  region = 'your_region';

List backup jobs with long duration

Identify backup jobs that have taken longer than expected to complete. This helps in identifying performance bottlenecks and optimizing backup processes.

select
  name,
  id,
  duration,
  start_time,
  end_time,
  status
from
  azure_data_protection_backup_job
where
  duration > 'PT1H';
-- Jobs longer than 1 hour

select
  name,
  id,
  duration,
  start_time,
  end_time,
  status
from
  azure_data_protection_backup_job
where
  duration > 'PT1H';
-- Jobs longer than 1 hour

List backup jobs by status

Explore backup jobs based on their status to monitor ongoing and completed jobs, and to identify any jobs that may require attention.

select
  name,
  id,
  status,
  start_time,
  end_time
from
  azure_data_protection_backup_job
where
  status = 'InProgress';

select
  name,
  id,
  status,
  start_time,
  end_time
from
  azure_data_protection_backup_job
where
  status = 'InProgress';

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_data_protection_backup_job