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_systemorder by name;
select *from equinix_metal_operating_systemorder 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_systemgroup by distroorder by count desc;
select distro, count(*)from equinix_metal_operating_systemgroup by distroorder 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_systemwhere distro = 'ubuntu'order by name;
select *from equinix_metal_operating_systemwhere 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_systemwhere 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, devicefrom equinix_metal_operating_system, jsonb_array_elements_text(provisionable_on) as device;
select slug, device.valuefrom equinix_metal_operating_system, json_each(provisionable_on) as device;
Schema for equinix_metal_operating_system
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
distro | text | Distro of the operating system. | |
name | text | Name of the operating system. | |
provisionable_on | jsonb | Device types that the operating system can be provisioned on. | |
slug | text | Slug of the operating system. | |
version | text | Version 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