steampipe plugin install equinix

Table: equinix_metal_operating_system - Query Equinix Metal Operating Systems using SQL

Equinix Metal Operating System is a resource within the Equinix Metal infrastructure that defines the software on which a computer system runs. It manages the hardware resources of a computer and hosts applications that run on the computer. Equinix Metal Operating System is a key component in ensuring the efficient operation of your applications and services in the Equinix Metal environment.

Table Usage Guide

The equinix_metal_operating_system table provides insights into the operating systems within Equinix Metal. As a systems administrator or DevOps engineer, you can explore details about each operating system through this table, including its name, version, and other relevant properties. Utilize it to manage and optimize the performance of your applications and services running on these operating systems.

Examples

List all

Explore all available operating systems in the Equinix Metal service, sorted by name. This can be useful in determining which operating systems are available for deployment.

select
*
from
equinix_metal_operating_system
order by
name;
select
*
from
equinix_metal_operating_system
order by
name;

Group by distribution

Analyze the distribution of different operating systems in use within your Equinix Metal infrastructure. This can help identify the most commonly used systems and inform decisions regarding system support and maintenance.

select
distro,
count(*)
from
equinix_metal_operating_system
group by
distro
order by
count desc;
select
distro,
count(*)
from
equinix_metal_operating_system
group by
distro
order by
count(*) desc;

List all Ubuntu OS versions available

Explore the various Ubuntu operating system versions available to understand the range of options for your system setup. This is beneficial for assessing compatibility and planning system upgrades.

select
*
from
equinix_metal_operating_system
where
distro = 'ubuntu'
order by
name;
select
*
from
equinix_metal_operating_system
where
distro = 'ubuntu'
order by
name;

Which operating systems can be provisioned on a c3.medium.x86 device?

Determine the variety of operating systems that can be installed on a specific device model. This is useful for understanding the flexibility and compatibility of different devices in your network.

select
*
from
equinix_metal_operating_system
where
provisionable_on ? 'c3.medium.x86';
Error: SQLite does not support the '?' operator used for JSON objects in PostgreSQL.

List all OS device combinations

Explore various operating system and device combinations that can be provisioned on Equinix Metal. This can be useful for assessing compatibility and planning infrastructure deployment.

select
slug,
device
from
equinix_metal_operating_system,
jsonb_array_elements_text(provisionable_on) as device;
select
slug,
device.value
from
equinix_metal_operating_system,
json_each(provisionable_on) as device;

Schema for equinix_metal_operating_system

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
distrotextDistro of the operating system.
nametextName of the operating system.
provisionable_onjsonbDevice types that the operating system can be provisioned on.
slugtextSlug of the operating system.
versiontextVersion of the operating system.

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)" -- equinix

You can pass the configuration to the command with the --config argument:

steampipe_export_equinix --config '<your_config>' equinix_metal_operating_system