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	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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