turbot/azure

steampipe plugin install azuresteampipe plugin install azure
On This Page
Get Involved

Table: azure_api_management

Azure API Management is a fully managed service that enables customers to publish, secure, transform, maintain, and monitor APIs.

Examples

Public and private IP address info of each API management

select
name,
public_ip_addresses,
private_ip_addresses
from
azure_api_management;

API management publisher info

select
name,
publisher_name,
publisher_email
from
azure_api_management;

List of premium API managements and their computing capacity

select
name,
sku_name,
sku_capacity
from
azure_api_management
where
sku_name = 'Premium';

List of API management without application tag key

select
name,
tags
from
azure_api_management
where
not tags :: JSONB ? 'application';

.inspect azure_api_management

Azure API Management Service

NameTypeDescription
additional_locationsjsonbAdditional datacenter locations of the API Management service
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
created_at_utctimestamp without time zoneCreation UTC date of the API Management service
etagtextAn unique read-only string that changes whenever the resource is updated
gateway_regional_urltextGateway URL of the API Management service in the Default Region
gateway_urltextGateway URL of the API Management service
host_name_configurationsjsonbA list of custom hostname configuration of the API Management service
idtextContains ID to identify an api management uniquely
identity_principal_idtextThe principal id of the identity
identity_tenant_idtextThe client tenant id of the identity
identity_typetextThe type of identity used for the resource
management_api_urltextManagement API endpoint URL of the API Management service
nametextA friendly name that identifies an api management
notification_sender_emailtextEmail address from which the notification will be sent
portal_urltextPublisher portal endpoint Url of the API Management service
private_ip_addressesjsonbA list of private Static Load Balanced IP addresses of the API Management service in Primary region which is deployed in an Internal Virtual Network
provisioning_statetextThe current provisioning state of the API Management service
public_ip_addressesjsonbA list of public Static Load Balanced IP addresses of the API Management service in Primary region
publisher_emailtextEmail address of the publisher of the API Management service
publisher_nametextName of the publisher of the API Management service
regiontextThe Azure region/location in which the resource is located.
resource_grouptextThe resource group which holds this resource.
sku_capacitybigintCapacity of the SKU (number of deployed units of the SKU)
sku_nametextName of the Sku
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
target_provisioning_statetextThe provisioning state of the API Management service, which is targeted by the long running operation started on the service
titletextTitle of the resource.
typetextType of the resource
virtual_network_configuration_idtextContains the virtual network ID
virtual_network_configuration_subnet_nametextContains the name of the subnet
virtual_network_configuration_subnet_resource_idtextThe full resource ID of a subnet in a virtual network to deploy the API Management service in