Table: azure_recovery_services_vault - Query Azure Recovery Services Vaults using SQL

Azure Recovery Services Vault is a backup service within Microsoft Azure that allows you to protect and recover your data and applications. It provides a centralized place to manage backups and disaster recovery, and it supports a range of Azure services, including virtual machines, SQL databases, and file shares. Azure Recovery Services Vault helps you ensure the availability and integrity of your Azure resources.

Table Usage Guide

The azure_recovery_services_vault table provides insights into Recovery Services Vaults within Azure. As a system administrator, you can use this table to explore vault-specific details, including backup policies, protected items, and recovery points. This table is especially useful for ensuring that your backup and recovery strategies are properly implemented and managed.

Examples

Basic info

Explore the various elements of your Azure Recovery Services Vaults, such as their names, IDs, regions, and types. This can be useful in understanding the overall structure and organization of your vaults, aiding in better management and oversight.

select
  name,
  id,
  region,
  type
from
  azure_recovery_services_vault;

select
  name,
  id,
  region,
  type
from
  azure_recovery_services_vault;

List failed recovery service vaults

Discover the segments that have unsuccessful recovery service vaults in Azure, which can be crucial for identifying and addressing potential issues in your data recovery strategy. This query is beneficial in maintaining robust data protection and business continuity plans.

select
  name,
  id,
  type,
  provisioning_state,
  region
from
  azure_recovery_services_vault
where
  provisioning_state = 'Failed';

select
  name,
  id,
  type,
  provisioning_state,
  region
from
  azure_recovery_services_vault
where
  provisioning_state = 'Failed';

Control examples

Schema for azure_recovery_services_vault

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.
diagnostic_settings	jsonb		A list of active diagnostic settings for the recovery services vault.
etag	text		An unique read-only string that changes whenever the resource is updated.
id	text		The resource identifier.
identity	jsonb		Managed service identity of the recovery services vault.
name	text	=	The resource name.
private_endpoint_connections	jsonb		List of private endpoint connections of the recovery services vault.
private_endpoint_state_for_backup	text		Private endpoint state for backup of the recovery services vault.
private_endpoint_state_for_site_recovery	text		Private endpoint state for site recovery of the recovery services vault.
provisioning_state	text		The provisioning state of the recovery services vault.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
sku_name	text		The sku name of the recovery services vault.
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		The resource type.
upgrade_details	jsonb		Upgrade details properties of the recovery services vault.

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_vault