steampipe plugin install azure

Table: azure_spring_cloud_service - Query Azure Spring Cloud Services using SQL

Azure Spring Cloud is a fully managed service for Spring Boot apps that lets you focus on building and running the apps that run your business without the hassle of managing infrastructure. It provides a platform for deploying and managing Spring Boot and Spring Cloud applications in the cloud. The service is jointly built, operated, and supported by Pivotal Software and Microsoft to provide a native platform designed to be easily run and managed on Azure.

Table Usage Guide

The azure_spring_cloud_service table provides insights into Azure Spring Cloud Services within Microsoft Azure. As a DevOps engineer, explore service-specific details through this table, including configurations, provisioning state, and associated metadata. Utilize it to uncover information about services, such as service versions, the network profile of the service, and the verification of service configurations.

Examples

Basic info

Explore the fundamental details of your Azure Spring Cloud services, such as their provisioning state, SKU details, and version. This can be used to assess the status and tier of your services, enabling effective management and optimization.

select
id,
name,
type,
provisioning_state,
sku_name,
sku_tier,
version
from
azure_spring_cloud_service;
select
id,
name,
type,
provisioning_state,
sku_name,
sku_tier,
version
from
azure_spring_cloud_service;

List network profile details

Assess the elements within your Azure Spring Cloud Service's network profile. This query can be used to gain insights into the specific configurations and resource groups associated with your network profile, which can aid in network management and troubleshooting.

select
id,
name,
network_profile ->> 'AppNetworkResourceGroup' as network_profile_app_network_resource_group,
network_profile ->> 'AppSubnetID' as network_profile_app_subnet_id,
jsonb_pretty(network_profile -> 'OutboundPublicIPs') as network_profile_outbound_public_ips,
network_profile ->> 'ServiceCidr' as network_profile_service_cidr,
network_profile ->> 'ServiceRuntimeNetworkResourceGroup' as network_profile_service_runtime_network_resource_group,
network_profile ->> 'ServiceRuntimeSubnetID' as network_profile_service_runtime_subnet_id
from
azure_spring_cloud_service;
select
id,
name,
json_extract(network_profile, '$.AppNetworkResourceGroup') as network_profile_app_network_resource_group,
json_extract(network_profile, '$.AppSubnetID') as network_profile_app_subnet_id,
network_profile -> 'OutboundPublicIPs' as network_profile_outbound_public_ips,
json_extract(network_profile, '$.ServiceCidr') as network_profile_service_cidr,
json_extract(
network_profile,
'$.ServiceRuntimeNetworkResourceGroup'
) as network_profile_service_runtime_network_resource_group,
json_extract(network_profile, '$.ServiceRuntimeSubnetID') as network_profile_service_runtime_subnet_id
from
azure_spring_cloud_service;

Schema for azure_spring_cloud_service

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
diagnostic_settingsjsonbA list of active diagnostic settings for the resource.
idtextFully qualified resource Id for the resource.
nametext=The name of the resource.
network_profilejsonbNetwork profile of the service.
provisioning_statetextProvisioning state of the Service. Possible values include: 'Creating', 'Updating', 'Deleting', 'Deleted', 'Succeeded', 'Failed', 'Moving', 'Moved', 'MoveFailed'.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
service_idtextService instance entity GUID which uniquely identifies a created resource.
sku_capacitybigintCurrent capacity of the target resource.
sku_nametextName of the Sku.
sku_tiertextTier of the Sku.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe type of the resource.
versionbigintVersion of the service.

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_spring_cloud_service