Table: azure_resource_link - Query Azure Resource Links using SQL

Azure Resource Links is a feature within Microsoft Azure that allows you to create and manage links between resources. These links can be used for organizing resources and defining dependencies between them. Azure Resource Links helps you to understand the relationships and dependencies between your Azure resources.

Table Usage Guide

The azure_resource_link table provides insights into the interconnections between various Azure resources. As a cloud architect or a DevOps engineer, you can explore link-specific details through this table, including the source and target of each link, and the properties of the link. Utilize it to uncover information about resource dependencies, such as those with circular dependencies or orphaned resources, and to aid in resource management and organization.

Examples

Basic Info

Discover the segments that connect different resources in your Azure environment. This query is particularly useful for understanding the relationships and dependencies between your resources, aiding in efficient resource management and troubleshooting.

select
  name,
  id,
  type,
  source_id,
  target_id
from
  azure_resource_link;

select
  name,
  id,
  type,
  source_id,
  target_id
from
  azure_resource_link;

List resource links with virtual machines

Determine the areas in which resources are linked with virtual machines in your Azure environment. This can be useful for managing and understanding dependencies between your resources.

select
  name,
  id,
  source_id,
  target_id
from
  azure_resource_link
where
  source_id LIKE '%virtualmachines%';

select
  name,
  id,
  source_id,
  target_id
from
  azure_resource_link
where
  source_id LIKE '%virtualmachines%';

Control examples

Audit virtual machines without disaster recovery configured

Schema for azure_resource_link

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.
id	text	=	The fully qualified ID of the resource link.
name	text		The name of the resource link.
notes	text		Notes about the resource link.
resource_group	text		The resource group which holds this resource.
source_id	text		The fully qualified ID of the source resource in the link.
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.
target_id	text		The fully qualified ID of the target resource in the link.
title	text		Title of the resource.
type	text		The resource link type.

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_resource_link