steampipe plugin install azuresteampipe plugin install azure
azure_ad_groupazure_ad_service_principalazure_ad_userazure_alert_managementazure_api_managementazure_api_management_backendazure_app_configurationazure_app_service_environmentazure_app_service_function_appazure_app_service_planazure_app_service_web_appazure_app_service_web_app_slotazure_application_gatewayazure_application_insightazure_application_security_groupazure_automation_accountazure_automation_variableazure_bastion_hostazure_batch_accountazure_cognitive_accountazure_compute_availability_setazure_compute_diskazure_compute_disk_accessazure_compute_disk_encryption_setazure_compute_disk_metric_read_opsazure_compute_disk_metric_read_ops_dailyazure_compute_disk_metric_read_ops_hourlyazure_compute_disk_metric_write_opsazure_compute_disk_metric_write_ops_dailyazure_compute_disk_metric_write_ops_hourlyazure_compute_imageazure_compute_resource_skuazure_compute_snapshotazure_compute_ssh_keyazure_compute_virtual_machineazure_compute_virtual_machine_metric_cpu_utilizationazure_compute_virtual_machine_metric_cpu_utilization_dailyazure_compute_virtual_machine_metric_cpu_utilization_hourlyazure_compute_virtual_machine_scale_setazure_compute_virtual_machine_scale_set_network_interfaceazure_compute_virtual_machine_scale_set_vmazure_consumption_usageazure_container_groupazure_container_registryazure_cosmosdb_accountazure_cosmosdb_mongo_collectionazure_cosmosdb_mongo_databaseazure_cosmosdb_restorable_database_accountazure_cosmosdb_sql_databaseazure_data_factoryazure_data_factory_datasetazure_data_factory_pipelineazure_data_lake_analytics_accountazure_data_lake_storeazure_databox_edge_deviceazure_databricks_workspaceazure_diagnostic_settingazure_dns_zoneazure_eventgrid_domainazure_eventgrid_topicazure_eventhub_namespaceazure_express_route_circuitazure_firewallazure_firewall_policyazure_frontdoorazure_hdinsight_clusterazure_healthcare_serviceazure_hpc_cacheazure_hybrid_compute_machineazure_hybrid_kubernetes_connected_clusterazure_iothubazure_iothub_dpsazure_key_vaultazure_key_vault_deleted_vaultazure_key_vault_keyazure_key_vault_key_versionazure_key_vault_managed_hardware_security_moduleazure_key_vault_secretazure_kubernetes_clusterazure_kubernetes_service_versionazure_kusto_clusterazure_lbazure_lb_backend_address_poolazure_lb_nat_ruleazure_lb_outbound_ruleazure_lb_probeazure_lb_ruleazure_locationazure_log_alertazure_log_profileazure_logic_app_workflowazure_machine_learning_workspaceazure_management_groupazure_management_lockazure_mariadb_serverazure_monitor_activity_log_eventazure_monitor_log_profileazure_mssql_elasticpoolazure_mssql_managed_instanceazure_mssql_virtual_machineazure_mysql_flexible_serverazure_mysql_serverazure_nat_gatewayazure_network_interfaceazure_network_security_groupazure_network_watcherazure_network_watcher_flow_logazure_policy_assignmentazure_policy_definitionazure_postgresql_flexible_serverazure_postgresql_serverazure_private_dns_zoneazure_providerazure_public_ipazure_recovery_services_backup_jobazure_recovery_services_vaultazure_redis_cacheazure_resource_groupazure_resource_linkazure_role_assignmentazure_role_definitionazure_route_tableazure_search_serviceazure_security_center_auto_provisioningazure_security_center_automationazure_security_center_contactazure_security_center_jit_network_access_policyazure_security_center_settingazure_security_center_sub_assessmentazure_security_center_subscription_pricingazure_service_fabric_clusterazure_servicebus_namespaceazure_signalr_serviceazure_spring_cloud_serviceazure_sql_databaseazure_sql_serverazure_storage_accountazure_storage_blobazure_storage_blob_serviceazure_storage_containerazure_storage_queueazure_storage_share_fileazure_storage_syncazure_storage_tableazure_storage_table_serviceazure_stream_analytics_jobazure_subnetazure_subscriptionazure_synapse_workspaceazure_tenantazure_virtual_networkazure_virtual_network_gateway

Table: azure_public_ip - Query Azure Public IPs using SQL

Azure Public IP is a service in Microsoft Azure that allows you to allocate a public IP address to Azure resources such as virtual machines, load balancers, and VPN gateways. It provides a way to communicate with the internet, a private network, or both. Azure Public IP helps you manage network connectivity and access, ensuring that your Azure resources are reachable and responsive.

Table Usage Guide

The azure_public_ip table provides insights into Public IPs within Microsoft Azure. As a network administrator, explore IP-specific details through this table, including IP address, allocation method, and associated metadata. Utilize it to uncover information about network configurations, such as those with static or dynamic allocation, the IP version (IPv4 or IPv6), and the verification of IP tags.

Examples

List of unassociated elastic IPs

Discover the segments that consist of unassigned public IPs in your Azure infrastructure. This is useful in identifying potential cost savings, as you may be billed for these unassociated resources.

select
name,
ip_configuration_id
from
azure_public_ip
where
ip_configuration_id is null;
select
name,
ip_configuration_id
from
azure_public_ip
where
ip_configuration_id is null;

List of IP addresses with corresponding associations

Explore the relationships between various IP addresses and their corresponding resources in your Azure environment. This can aid in managing network configurations and identifying potential issues.

select
name,
ip_address,
split_part(ip_configuration_id, '/', 8) as resource,
split_part(ip_configuration_id, '/', 9) as resource_name
from
azure_public_ip;
Error: SQLite does not support split
or string_to_array functions.

List of dynamic IP addresses

Discover the segments that utilize dynamic IP allocation in your Azure environment. This helps in understanding the networking configuration and managing resources effectively.

select
name,
public_ip_allocation_method
from
azure_public_ip
where
public_ip_allocation_method = 'Dynamic';
select
name,
public_ip_allocation_method
from
azure_public_ip
where
public_ip_allocation_method = 'Dynamic';

Query examples

Control examples

Schema for azure_public_ip

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
ddos_custom_policy_idtextThe DDoS custom policy associated with the public IP
ddos_settings_protected_ipbooleanIndicates whether DDoS protection is enabled on the public IP, or not
ddos_settings_protection_coveragetextThe DDoS protection policy customizability of the public IP
dns_settings_domain_name_labeltextContains the domain name label
dns_settings_fqdntextThe Fully Qualified Domain Name of the A DNS record associated with the public IP
dns_settings_reverse_fqdntextContains the reverse FQDN
etagtextAn unique read-only string that changes whenever the resource is updated
idtextContains ID to identify a public ip uniquely
idle_timeout_in_minutesbigintThe idle timeout of the public IP address
ip_addressinetThe IP address associated with the public IP address resource
ip_configuration_idtextContains the IP configuration ID
ip_tagsjsonbA list of tags associated with the public IP address
nametext=The friendly name that identifies the public ip
provisioning_statetextThe resource type of the public ip
public_ip_address_versiontextContains the public IP address version
public_ip_allocation_methodtextContains the public IP address allocation method
public_ip_prefix_idtextThe Public IP Prefix this Public IP Address should be allocated from
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
resource_guidtextThe resource GUID property of the public ip resource
sku_nametextName of a public IP address SKU
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe resource type of the public ip
zonesjsonbA collection of availability zones denoting the IP allocated for the resource needs to come from

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_public_ip