steampipe 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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
agent_public_key_certificatetextBase64 encoded public certificate used by the agent to do the initial handshake to the backend services in Azure.
agent_versiontextVersion of the agent running on the connected cluster resource.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
connectivity_statustextRepresents the connectivity status of the connected cluster.
created_attimestamp with time zoneThe timestamp of resource creation (UTC).
created_bytextThe identity that created the resource.
created_by_typetextThe type of identity that created the resource.
distributiontextThe Kubernetes distribution running on this connected cluster.
extensionsjsonbThe extensions of the connected cluster.
idtextThe resource ID.
identityjsonbThe identity of the connected cluster.
infrastructuretextThe infrastructure on which the Kubernetes cluster represented by this connected cluster is running on.
kubernetes_versiontextThe Kubernetes version of the connected cluster resource.
last_connectivity_timetimestamp with time zoneTime representing the last instance when heart beat was received from the cluster.
last_modified_attimestamp with time zoneThe timestamp of resource last modification (UTC).
last_modified_bytextThe identity that last modified the resource.
last_modified_by_typetextThe type of identity that last modified the resource.
locationtextLocation of the resource.
managed_identity_certificate_expiration_timetimestamp with time zoneExpiration time of the managed identity certificate.
nametext=The name of the resource.
offeringtextConnected cluster offering.
provisioning_statetextThe provisioning state of the connected cluster resource.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
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.
total_core_countbigintNumber of CPU cores present in the connected cluster resource.
total_node_countbigintNumber of nodes present in the connected cluster resource.
typetextThe 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