Table: azure_recovery_services_backup_job - Query Azure Recovery Services Backup Jobs using SQL

Azure Recovery Services is a service within Microsoft Azure that provides data backup and disaster recovery capabilities. It allows you to protect and recover your data in the Microsoft cloud, providing a simple, secure, and cost-effective solution for protecting your data and maintaining business continuity. The service supports backup and recovery for Azure VMs, SQL Server, Azure SQL Database, on-premises Windows Servers, and more.

Table Usage Guide

The azure_recovery_services_backup_job table provides insights into backup jobs within Azure Recovery Services. As a system administrator or a backup operator, explore job-specific details through this table, including job status, duration, and details. Utilize it to monitor the status of backup operations, identify any issues, and ensure the successful completion of backup jobs.

Examples

Basic info

Determine the areas in which specific Azure recovery services backup jobs are performed, focusing on a specific vault. This can help to assess the distribution and management of backup jobs within your Azure environment.

select
  name,
  id,
  type,
  vault_name,
  region
from
  azure_recovery_services_backup_job
where
  vault_name = 'my-vault';

select
  name,
  id,
  type,
  vault_name,
  region
from
  azure_recovery_services_backup_job
where
  vault_name = 'my-vault';

Get job properties of jobs

Discover the specifics of job properties in your backup jobs. This can help you understand the type of job, its management, operational status, and timing details, providing critical insights into your backup operations.

select
  name,
  id,
  properties ->> 'JobType' as job_type,
  properties ->> 'ActivityID' as activity_id,
  properties ->> 'BackupManagementType' as backup_management_type,
  properties ->> 'EndTime' as end_time,
  properties ->> 'EntityFriendlyName' as entity_friendly_name,
  properties ->> 'Operation' as Operation,
  properties ->> 'StartTime' as start_time,
  properties ->> 'Status' as Status
from
  azure_recovery_services_backup_job;

select
  name,
  id,
  json_extract(properties, '$.JobType') as job_type,
  json_extract(properties, '$.ActivityID') as activity_id,
  json_extract(properties, '$.BackupManagementType') as backup_management_type,
  json_extract(properties, '$.EndTime') as end_time,
  json_extract(properties, '$.EntityFriendlyName') as entity_friendly_name,
  json_extract(properties, '$.Operation') as Operation,
  json_extract(properties, '$.StartTime') as start_time,
  json_extract(properties, '$.Status') as Status
from
  azure_recovery_services_backup_job;

Schema for azure_recovery_services_backup_job

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cloud_environment	text		The Azure Cloud Environment.
etag	text		Optional ETag.
id	text		Resource ID represents the complete path to the resource.
name	text		Resource name associated with the resource.
properties	jsonb		JobResource properties.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		Resource type represents the complete path of the form Namespace/ResourceType/ResourceType/...
vault_name	text	=	The recovery vault name.

Export

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_recovery_services_backup_job