steampipe plugin install azuresteampipe plugin install azure

Table: azure_hybrid_kubernetes_connected_cluster - Query Azure Hybrid Kubernetes Connected Clusters using SQL

Azure Hybrid Kubernetes Connected Clusters is a feature offered by Microsoft Azure that allows users to manage and govern Kubernetes clusters across on-premises, edge, and multi-cloud environments from a single pane of glass. Its unified approach offers consistent visibility, governance, and control across different environments, making it easier to manage Kubernetes resources. It provides a comprehensive view of all Kubernetes applications, irrespective of where they are running.

Table Usage Guide

The azure_hybrid_kubernetes_connected_cluster table provides insights into Hybrid Kubernetes Connected Clusters within Microsoft Azure. As a DevOps engineer, this table can be utilized to explore cluster-specific details, including configuration, status, and associated properties. Use it to uncover information about clusters, such as their health status, the Kubernetes version they're running, and their connectivity state with Azure.

Examples

Basic info

Explore which Azure Hybrid Kubernetes clusters are currently connected and their respective provisioning states. This can help in assessing the overall health and status of your hybrid cloud infrastructure.

select
  name,
  id,
  connectivity_status,
  provisioning_state,
  region
from
  azure_hybrid_kubernetes_connected_cluster;

select
  name,
  id,
  connectivity_status,
  provisioning_state,
  region
from
  azure_hybrid_kubernetes_connected_cluster;

List expired clusters

Explore which hybrid Kubernetes clusters in your Azure environment have expired connectivity. This is useful in maintaining an up-to-date and secure network by promptly addressing any expired clusters.

select
  name,
  id,
  type,
  provisioning_state,
  connectivity_status,
  region
from
  azure_hybrid_kubernetes_connected_cluster
where
  connectivity_status = 'Expired';

select
  name,
  id,
  type,
  provisioning_state,
  connectivity_status,
  region
from
  azure_hybrid_kubernetes_connected_cluster
where
  connectivity_status = 'Expired';

Schema for azure_hybrid_kubernetes_connected_cluster

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
agent_public_key_certificate	text		Base64 encoded public certificate used by the agent to do the initial handshake to the backend services in Azure.
agent_version	text		Version of the agent running on the connected cluster resource.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cloud_environment	text		The Azure Cloud Environment.
connectivity_status	text		Represents the connectivity status of the connected cluster.
created_at	timestamp with time zone		The timestamp of resource creation (UTC).
created_by	text		The identity that created the resource.
created_by_type	text		The type of identity that created the resource.
distribution	text		The Kubernetes distribution running on this connected cluster.
extensions	jsonb		The extensions of the connected cluster.
id	text		The resource ID.
identity	jsonb		The identity of the connected cluster.
infrastructure	text		The infrastructure on which the Kubernetes cluster represented by this connected cluster is running on.
kubernetes_version	text		The Kubernetes version of the connected cluster resource.
last_connectivity_time	timestamp with time zone		Time representing the last instance when heart beat was received from the cluster.
last_modified_at	timestamp with time zone		The timestamp of resource last modification (UTC).
last_modified_by	text		The identity that last modified the resource.
last_modified_by_type	text		The type of identity that last modified the resource.
location	text		Location of the resource.
managed_identity_certificate_expiration_time	timestamp with time zone		Expiration time of the managed identity certificate.
name	text	=	The name of the resource.
offering	text		Connected cluster offering.
provisioning_state	text		The provisioning state of the connected cluster resource.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
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.
total_core_count	bigint		Number of CPU cores present in the connected cluster resource.
total_node_count	bigint		Number of nodes present in the connected cluster resource.
type	text		The type of the resource.

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_hybrid_kubernetes_connected_cluster