steampipe plugin install updown

Table: updown_check - Query Updown.io Checks using SQL

Updown.io is a website monitoring service that checks your website's status every few seconds from different locations around the world. It provides detailed reports of uptime, downtime, and performance metrics. This service helps you stay informed about the health and performance of your website and take appropriate actions when predefined conditions are met.

Table Usage Guide

The updown_check table provides insights into Checks within Updown.io. As a Site Reliability Engineer, explore check-specific details through this table, including uptime, downtime, and associated metadata. Utilize it to uncover information about checks, such as those with significant downtime, the performance metrics of each check, and the verification of uptime reports.

Examples

List all checks

Explore all monitoring checks in your system to better understand the health and performance of your digital assets. This can help you proactively identify potential issues and rectify them before they escalate.

select
*
from
updown_check;
select
*
from
updown_check;

Get a check by token

Discover the segments that correspond to a specific identifier in order to analyze and manage system checks more efficiently. This can be useful in pinpointing specific checks for troubleshooting or system optimization.

select
*
from
updown_check
where
token = 'sdfw';
select
*
from
updown_check
where
token = 'sdfw';

List checks that are currently down

Identify instances where certain checks are currently down. This can assist in promptly addressing and rectifying any issues that might be affecting system performance or functionality.

select
*
from
updown_check
where
down;
select
*
from
updown_check
where
down = 1;

Schema for updown_check

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
aliastextAlias for the check.
apdex_thresholddouble precisionAPDEX (Application Performance Index) threshold in seconds (0.125, 0.25, 0.5, 1.0 or 2.0).
disabled_locationsjsonbDisabled monitoring locations. It's an array of abbreviated location names. Can be any of these: lan, mia, bhs, rbx, fra, sin, tok, syd.
downbooleanTrue if the URL is down.
down_sincetimestamp with time zoneThe URL has been down since this time. Null if the URL is up.
enabledbooleanTrue if the check is enabled.
errortextError from the check, if any.
favicon_urltextFavicon for the URL.
last_check_attimestamp with time zoneTime of the last check.
last_statusbigintLast status of the check.
mute_untiltimestamp with time zoneCheck is muted until this time.
next_check_attimestamp with time zoneTime when the next check will be performed.
periodbigintInterval in seconds (15, 30, 60, 120, 300, 600, 1800 or 3600).
publishedbooleanTrue if the status of the check is public.
ssljsonbSSL information.
tokentext=The check unique token.
uptimedouble precisionUptime (percentage) for the check.
urltextThe URL being monitored.

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_check