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;

Control examples

Azure Spring Cloud should use network injection

Schema for azure_spring_cloud_service

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.
diagnostic_settings	jsonb		A list of active diagnostic settings for the resource.
id	text		Fully qualified resource Id for the resource.
name	text	=	The name of the resource.
network_profile	jsonb		Network profile of the service.
provisioning_state	text		Provisioning state of the Service. Possible values include: 'Creating', 'Updating', 'Deleting', 'Deleted', 'Succeeded', 'Failed', 'Moving', 'Moved', 'MoveFailed'.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
service_id	text		Service instance entity GUID which uniquely identifies a created resource.
sku_capacity	bigint		Current capacity of the target resource.
sku_name	text		Name of the Sku.
sku_tier	text		Tier of the Sku.
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.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The type of the resource.
version	bigint		Version 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