Table: updown_node - Query Updown.io Nodes using SQL

Updown.io is a simple and inexpensive website monitoring service that checks your website's status at regular intervals. It provides detailed metrics about your site's uptime, response time, and error analysis. Updown.io allows you to monitor HTTP(s), TCP, and ICMP to ensure your services are always up and running.

Table Usage Guide

The updown_node table provides insights into nodes within Updown.io's monitoring service. As a DevOps engineer, explore node-specific details through this table, including node status, response time, and associated metadata. Utilize it to uncover information about nodes, such as their performance, uptime, and any potential issues or anomalies.

Examples

List all nodes

Explore the nodes within your network in a structured order, providing a comprehensive overview to facilitate management and troubleshooting. This query is useful in identifying potential issues or anomalies within your network.

select
  *
from
  updown_node
order by
  name;

select
  *
from
  updown_node
order by
  name;

Schema for updown_node

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
city	text	City of the node.
country	text	Country of the node.
country_code	text	Country code of the node.
ip	inet	IPv4 address of the node.
ip6	inet	IPv6 address of the node.
name	text	IPv4 address of the node.

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

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

steampipe_export_updown --config '<your_config>' updown_node