v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins Mods Docs Home

turbot/azure

steampipe plugin install azuresteampipe plugin install azure

azure_alert_management azure_api_management azure_api_management_backend azure_app_configuration azure_app_service_environment azure_app_service_function_app azure_app_service_plan azure_app_service_web_app azure_app_service_web_app_slot azure_application_gateway azure_application_insight azure_application_security_group azure_automation_account azure_automation_variable azure_backup_policy azure_bastion_host azure_batch_account azure_cdn_frontdoor_profile azure_cognitive_account azure_compute_availability_set azure_compute_disk azure_compute_disk_access azure_compute_disk_encryption_set azure_compute_disk_metric_read_ops azure_compute_disk_metric_read_ops_daily azure_compute_disk_metric_read_ops_hourly azure_compute_disk_metric_write_ops azure_compute_disk_metric_write_ops_daily azure_compute_disk_metric_write_ops_hourly azure_compute_image azure_compute_resource_sku azure_compute_snapshot azure_compute_ssh_key azure_compute_virtual_machine azure_compute_virtual_machine_metric_available_memory azure_compute_virtual_machine_metric_available_memory_daily azure_compute_virtual_machine_metric_available_memory_hourly azure_compute_virtual_machine_metric_cpu_utilization azure_compute_virtual_machine_metric_cpu_utilization_daily azure_compute_virtual_machine_metric_cpu_utilization_hourly azure_compute_virtual_machine_scale_set azure_compute_virtual_machine_scale_set_network_interface azure_compute_virtual_machine_scale_set_vm azure_compute_virtual_machine_size azure_consumption_usage azure_container_group azure_container_registry azure_cosmosdb_account azure_cosmosdb_mongo_collection azure_cosmosdb_mongo_database azure_cosmosdb_restorable_database_account azure_cosmosdb_sql_database azure_data_factory azure_data_factory_dataset azure_data_factory_pipeline azure_data_lake_analytics_account azure_data_lake_store azure_data_protection_backup_job azure_data_protection_backup_vault azure_databox_edge_device azure_databricks_workspace azure_diagnostic_setting azure_dns_zone azure_eventgrid_domain azure_eventgrid_topic azure_eventhub_namespace azure_express_route_circuit azure_firewall azure_firewall_policy azure_frontdoor azure_hdinsight_cluster azure_healthcare_service azure_hpc_cache azure_hybrid_compute_machine azure_hybrid_kubernetes_connected_cluster azure_iothub azure_iothub_dps azure_key_vault azure_key_vault_certificate azure_key_vault_deleted_vault azure_key_vault_key azure_key_vault_key_version azure_key_vault_managed_hardware_security_module azure_key_vault_secret azure_kubernetes_cluster azure_kubernetes_service_version azure_kusto_cluster azure_lb azure_lb_backend_address_pool azure_lb_nat_rule azure_lb_outbound_rule azure_lb_probe azure_lb_rule azure_lighthouse_assignment azure_lighthouse_definition azure_location azure_log_alert azure_log_analytics_workspace azure_log_profile azure_logic_app_workflow azure_machine_learning_workspace azure_maintenance_configuration azure_management_group azure_management_lock azure_mariadb_server azure_monitor_activity_log_event azure_monitor_log_profile azure_mssql_elasticpool azure_mssql_managed_instance azure_mssql_virtual_machine azure_mysql_flexible_server azure_mysql_server azure_nat_gateway azure_network_interface azure_network_security_group azure_network_watcher azure_network_watcher_flow_log azure_policy_assignment azure_policy_definition azure_postgresql_flexible_server azure_postgresql_server azure_private_dns_zone azure_private_endpoint azure_provider azure_public_ip azure_recovery_services_backup_job azure_recovery_services_vault azure_redis_cache azure_resource azure_resource_group azure_resource_link azure_role_assignment azure_role_definition azure_route_table azure_search_service azure_security_center_auto_provisioning azure_security_center_automation azure_security_center_contact azure_security_center_jit_network_access_policy azure_security_center_setting azure_security_center_sub_assessment azure_security_center_subscription_pricing azure_service_fabric_cluster azure_servicebus_namespace azure_signalr_service azure_spring_cloud_service azure_sql_database azure_sql_server azure_storage_account azure_storage_blob azure_storage_blob_service azure_storage_container azure_storage_queue azure_storage_share_file azure_storage_sync azure_storage_table azure_storage_table_service azure_stream_analytics_job azure_subnet azure_subscription azure_synapse_workspace azure_tenant azure_virtual_network azure_virtual_network_gateway azure_web_application_firewall_policy

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;

Query examples

Control examples

Schema for azure_tenant

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.
country	text		Country/region name of the address for the tenant.
country_code	text		Country/region abbreviation for the tenant.
display_name	text		The list of domains for the tenant.
domains	jsonb		The list of domains for the tenant.
id	text		The fully qualified ID of the tenant. For example, /tenants/00000000-0000-0000-0000-000000000000.
name	text		The display name of the tenant.
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.
tenant_category	text		The tenant category. Possible values include: 'Home', 'ProjectedBy', 'ManagedBy'.
tenant_id	text		The tenant ID. For example, 00000000-0000-0000-0000-000000000000.
title	text		Title 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