Table: azure_data_protection_backup_vault - Query Azure Data Protection Backup Vaults using SQL

A Backup Vault in Azure Data Protection is a storage entity in Azure used to manage and store backups. Backup Vaults help in organizing your backups and configuring backup policies for your Azure resources.

Table Usage Guide

The azure_data_protection_backup_vault table provides insights into Backup Vaults within Azure. As an Infrastructure Engineer, explore detailed information about each backup vault through this table, including its identity, provisioning state, and storage settings. Use this table to manage and optimize your backup strategies, ensuring secure and efficient data protection for your Azure resources.

Examples

Basic backup vault information

Retrieve basic information about your Azure Backup Vaults, including their names, locations, and provisioning states.

select
  name,
  location,
  provisioning_state
from
  azure_data_protection_backup_vault;

select
  name,
  location,
  provisioning_state
from
  azure_data_protection_backup_vault;

Backup vault storage settings

Explore the storage settings of your Azure Backup Vaults. This can help you understand the storage configuration and optimize your backup storage strategies.

select
  name,
  s -> 'datastoreType' as datastore_type,
  s -> 'type' as storage_type
from
  azure_data_protection_backup_vault,
  jsonb_array_elements(storage_settings) as s;

select
  name,
  json_extract(s.value, '$.datastoreType') as datastore_type,
  json_extract(s.value, '$.type') as storage_type
from
  azure_data_protection_backup_vault,
  json_each(storage_settings) as s;

Managed identity details

List the managed identity details for each Backup Vault, which can be useful for managing access and security configurations.

select
  name,
  identity ->> 'type' as identity_type,
  identity -> 'principalId' as principal_id
from
  azure_data_protection_backup_vault;

select
  name,
  json_extract(identity, '$.type') as identity_type,
  json_extract(identity, '$.principalId') as principal_id
from
  azure_data_protection_backup_vault;

Backup vault tags

Retrieve tags associated with each Backup Vault to help with resource organization and management.

select
  name,
  jsonb_each_text(tags) as tag
from
  azure_data_protection_backup_vault;

select
  name,
  json_each(tags) as tag
from
  azure_data_protection_backup_vault;

Backup vaults in failed provisioning state

Retrieve information about backup vaults that are in a failed provisioning state. This can help in identifying and troubleshooting issues with backup vault deployment.

select
  name,
  s ->> 'datastoreType' as datastore_type,
  s ->> 'type' as storage_type
from
  azure_data_protection_backup_vault,
  jsonb_array_elements(storage_settings) as s
where
  provisioning_state = 'Failed';

select
  name,
  json_extract(s.value, '$.datastoreType') as datastore_type,
  json_extract(s.value, '$.type') as storage_type
from
  azure_data_protection_backup_vault,
  json_each(storage_settings) as s
where
  provisioning_state = 'Failed';

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_vault