Table: azure_hybrid_compute_machine - Query Azure Hybrid Compute Machines using SQL

Azure Hybrid Compute Machines are part of the Azure Arc service, which extends Azure services and management to any infrastructure. It enables management of Windows and Linux machines hosted outside of Azure, on the corporate network, or other cloud provider. This feature allows consistent Azure management across environments, providing a single control plane with access to the same familiar cloud-native Azure management experiences.

Table Usage Guide

The azure_hybrid_compute_machine table provides insights into Azure Hybrid Compute Machines within Azure Arc. As a system administrator, explore machine-specific details through this table, including machine properties, operating system details, and status information. Utilize it to uncover information about machines, such as their current provisioning state, the version of the installed agent, and the time of the last agent heartbeat.

Examples

Basic info

This query provides a way to gain insights into the status and location of your Azure hybrid compute machines. This can be useful for managing resources and ensuring optimal performance across different regions.

select
  name,
  id,
  status,
  provisioning_state,
  region
from
  azure_hybrid_compute_machine;

select
  name,
  id,
  status,
  provisioning_state,
  region
from
  azure_hybrid_compute_machine;

List disconnected machines

Explore which machines in your Azure hybrid computing environment are disconnected. This is useful to identify potential issues in your network and ensure all systems are functioning properly.

select
  name,
  id,
  type,
  provisioning_state,
  status,
  region
from
  azure_hybrid_compute_machine
where
  status = 'Disconnected';

select
  name,
  id,
  type,
  provisioning_state,
  status,
  region
from
  azure_hybrid_compute_machine
where
  status = 'Disconnected';

Control examples

Schema for azure_hybrid_compute_machine

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
ad_fqdn	text		Specifies the AD fully qualified display name.
agent_version	text		The hybrid machine agent full version.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
client_public_key	text		Public Key that the client provides to be used during initial resource onboarding.
cloud_environment	text		The Azure Cloud Environment.
display_name	text		Specifies the hybrid machine display name.
dns_fqdn	text		Specifies the DNS fully qualified display name.
domain_name	text		Specifies the Windows domain name.
error_details	jsonb		Details about the error state.
extensions	jsonb		The extensions of the compute machine.
id	text		The resource ID.
identity	jsonb		The identity of the compute machine.
last_status_change	timestamp with time zone		The time of the last status change.
location_data	jsonb		The metadata pertaining to the geographic location of the resource.
machine_fqdn	text		Specifies the hybrid machine FQDN.
machine_properties_extensions	jsonb		The machine properties extensions of the compute machine.
name	text	=	The name of the resource.
os_name	text		The Operating System running on the hybrid machine.
os_profile	jsonb		Specifies the operating system settings for the hybrid machine.
os_sku	text		Specifies the Operating System product SKU.
os_version	text		The version of Operating System running on the hybrid machine.
provisioning_state	text		The provisioning state of the hybrid machine.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The status of the hybrid machine agent.
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.
vm_id	text		Specifies the hybrid machine unique ID.
vm_uuid	text		Specifies the Arc Machine's unique SMBIOS ID.

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_compute_machine