steampipe plugin install azure

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';

Schema for azure_hybrid_compute_machine

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
ad_fqdntextSpecifies the AD fully qualified display name.
agent_versiontextThe hybrid machine agent full version.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
client_public_keytextPublic Key that the client provides to be used during initial resource onboarding.
cloud_environmenttextThe Azure Cloud Environment.
display_nametextSpecifies the hybrid machine display name.
dns_fqdntextSpecifies the DNS fully qualified display name.
domain_nametextSpecifies the Windows domain name.
error_detailsjsonbDetails about the error state.
extensionsjsonbThe extensions of the compute machine.
idtextThe resource ID.
identityjsonbThe identity of the compute machine.
last_status_changetimestamp with time zoneThe time of the last status change.
location_datajsonbThe metadata pertaining to the geographic location of the resource.
machine_fqdntextSpecifies the hybrid machine FQDN.
machine_properties_extensionsjsonbThe machine properties extensions of the compute machine.
nametext=The name of the resource.
os_nametextThe Operating System running on the hybrid machine.
os_profilejsonbSpecifies the operating system settings for the hybrid machine.
os_skutextSpecifies the Operating System product SKU.
os_versiontextThe version of Operating System running on the hybrid machine.
provisioning_statetextThe provisioning state of the hybrid machine.
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.
statustextThe status of the hybrid machine agent.
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.
vm_idtextSpecifies the hybrid machine unique ID.
vm_uuidtextSpecifies 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