turbot/equinix

steampipe plugin install equinixsteampipe plugin install equinix
On This Page
Get Involved

Table: equinix_metal_device

Devices (servers) from all projects visible to the user.

Examples

List all devices

select
*
from
equinix_metal_device

Get IP addresses for a device

select
jsonb_array_elements(ip_addresses)->>'address' as ip_address
from
equinix_metal_device
where
hostname = 'ny5-c3-medium-x86-01'

Find devices tagged as production

select
hostname,
tags
from
equinix_metal_device
where
tags->'production' is not null

Group devices by facility

select
f.code,
f.name,
count(*) as num_devices
from
equinix_metal_device as d,
equinix_metal_facility as f
where
d.facility_id = f.id
group by
f.code,
f.name
order by
num_devices desc

List devices with OS information

select
d.hostname,
os.name,
os.version
from
equinix_metal_device as d,
equinix_metal_operating_system as os
where
d.operating_system_slug = os.slug

Group devices by OS distribution

select
os.distro,
count(*)
from
equinix_metal_device as d,
equinix_metal_operating_system as os
where
d.operating_system_slug = os.slug
group by
os.distro
order by
count desc

.inspect equinix_metal_device

List all devices in all projects.

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
always_pxetextTrue if PXE is always enabled for the device.
billing_cycletextBilling cycle for the device.
created_attimestamp without time zoneWhen the device was created.
customdatajsonbCustom data associated with the device.
descriptiontextDescription of the device.
facility_idtextFacility for the device.
hardware_reservationjsonbHardware reservation for the device.
hostnametextHostname of the device.
hreftextURL of the device.
idtextID of the device.
ip_addressesjsonbNetwork configuration for the device.
ipxe_script_urltextIPXE script URL for the device.
lockedbooleanTrue if the device is locked.
metro_idtextMetro for the device.
network_portsjsonbList of network ports for the device.
operating_system_slugtextOS for the device.
plan_idtextPlan for the device.
project_idtextID of the Project.
provisioning_eventsjsonbProvisioning events for the device.
provisioning_percentagedouble precisionProvisioning percentage complete for the device.
root_passwordtextRoot password for the device. Only available for 24hr after launch.
short_idtextShort ID for the device.
spot_instancebooleanTrue if the device is a spot instance.
spot_price_maxdouble precisionMaximum spot price allowed for the device.
ssh_key_idsjsonbSSH Keys deployed to the device.
statetextState of the device.
storagejsonbStorage details for the device.
switch_uuidtextSwitch UUID for the device.
tagsjsonbA map of tags for the resource.
tags_srcjsonbTags for the device in source list form.
termination_timetimestamp without time zoneTime when the device was terminated.
titletextTitle of the resource.
updated_attimestamp without time zoneWhen the device was updated.
usertextUser for the device.
userdatatextUser data for the device.
volume_idsjsonbVolumes for the device.