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;

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