turbot/azure

steampipe plugin install azuresteampipe plugin install azure
azure_ad_groupazure_ad_service_principalazure_ad_userazure_api_managementazure_app_service_environmentazure_app_service_function_appazure_app_service_planazure_app_service_web_appazure_application_security_groupazure_batch_accountazure_compute_availability_setazure_compute_diskazure_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_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_container_registryazure_cosmosdb_accountazure_cosmosdb_mongo_databaseazure_cosmosdb_sql_databaseazure_data_factoryazure_data_factory_datasetazure_data_factory_pipelineazure_data_lake_analytics_accountazure_data_lake_storeazure_diagnostic_settingazure_eventhub_namespaceazure_express_route_circuitazure_firewallazure_iothubazure_key_vaultazure_key_vault_deleted_vaultazure_key_vault_keyazure_key_vault_managed_hardware_security_moduleazure_key_vault_secretazure_kubernetes_clusterazure_lbazure_lb_backend_address_poolazure_lb_nat_ruleazure_lb_outbound_ruleazure_lb_probeazure_lb_ruleazure_locationazure_log_alertazure_log_profileazure_logic_app_workflowazure_management_lockazure_mariadb_serverazure_mssql_elasticpoolazure_mssql_managed_instanceazure_mysql_serverazure_network_interfaceazure_network_security_groupazure_network_watcherazure_network_watcher_flow_logazure_policy_assignmentazure_policy_definitionazure_postgresql_serverazure_providerazure_public_ipazure_recovery_services_vaultazure_redis_cacheazure_resource_groupazure_resource_linkazure_role_assignmentazure_role_definitionazure_route_tableazure_search_serviceazure_security_center_auto_provisioningazure_security_center_contactazure_security_center_jit_network_access_policyazure_security_center_settingazure_security_center_subscription_pricingazure_servicebus_namespaceazure_sql_databaseazure_sql_serverazure_storage_accountazure_storage_blobazure_storage_blob_serviceazure_storage_containerazure_storage_queueazure_storage_tableazure_storage_table_serviceazure_stream_analytics_jobazure_subnetazure_subscriptionazure_tenantazure_virtual_networkazure_virtual_network_gateway

Table: azure_public_ip

Public IP addresses enable Azure resources to communicate to Internet and public-facing Azure services.

Examples

List of unassociated elastic IPs

select
name,
ip_configuration_id
from
azure_public_ip
where
ip_configuration_id is null;

List of IP addresses with corresponding associations

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;

List of dynamic IP addresses

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

.inspect azure_public_ip

Azure Public IP

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
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
nametextThe 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_grouptextThe 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