steampipe plugin install azure

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;

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%';

Schema for azure_resource_link

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
idtext=The fully qualified ID of the resource link.
nametextThe name of the resource link.
notestextNotes about the resource link.
resource_grouptextThe resource group which holds this resource.
source_idtextThe fully qualified ID of the source resource in the link.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
target_idtextThe fully qualified ID of the target resource in the link.
titletextTitle of the resource.
typetextThe 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