steampipe plugin install azure

Table: azure_tenant - Query Azure Tenants using SQL

Azure Tenants represent an organization in Azure. Each organization has at least one tenant, and each Azure subscription is associated with a tenant. Tenants are used to manage access to Azure resources.

Table Usage Guide

The azure_tenant table provides insights into the organizations associated with Azure subscriptions. As a Cloud Administrator, you can use this table to explore details such as tenant IDs and domains. This information can be useful for managing access to Azure resources and for understanding the organizational structure of your Azure subscriptions.

Examples

Basic info

Discover the segments that are part of your Azure tenant, including their geographical location and associated domains. This is useful for understanding the distribution and categorization of your Azure resources.

select
name,
id,
tenant_id,
tenant_category,
country,
country_code,
display_name,
domains
from
azure_tenant;
select
name,
id,
tenant_id,
tenant_category,
country,
country_code,
display_name,
domains
from
azure_tenant;

Control examples

Schema for azure_tenant

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
countrytextCountry/region name of the address for the tenant.
country_codetextCountry/region abbreviation for the tenant.
display_nametextThe list of domains for the tenant.
domainsjsonbThe list of domains for the tenant.
idtextThe fully qualified ID of the tenant. For example, /tenants/00000000-0000-0000-0000-000000000000.
nametextThe display name of the tenant.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tenant_categorytextThe tenant category. Possible values include: 'Home', 'ProjectedBy', 'ManagedBy'.
tenant_idtextThe tenant ID. For example, 00000000-0000-0000-0000-000000000000.
titletextTitle of the resource.

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_tenant