Table: uptimerobot_alert_contact - Query UptimeRobot Alert Contacts using SQL

UptimeRobot is a service that provides website monitoring, detecting downtime, and sending alerts. It allows you to monitor your websites, servers, and APIs in real-time and get alerted when they go down. Alert Contacts in UptimeRobot are the recipients of these alerts, which can be configured according to different parameters.

Table Usage Guide

The uptimerobot_alert_contact table provides insights into Alert Contacts within UptimeRobot. As a Site Reliability Engineer, explore alert contact-specific details through this table, including contact type, status, and associated metadata. Utilize it to understand the configuration of alert contacts, such as their value, type, and the thresholds for triggering alerts.

Examples

Basic info

Explore which alert contacts are active in UptimeRobot to manage your notifications effectively. This aids in understanding the types and statuses of your alert contacts, ensuring you're always informed about your site's uptime.

select
  id,
  friendly_name,
  type,
  status,
  value
from
  uptimerobot_alert_contact;

select
  id,
  friendly_name,
  type,
  status,
  value
from
  uptimerobot_alert_contact;

List Telegram alert contacts

Discover the segments that consist of Telegram alert contacts within your system, allowing you to assess the status and details of each contact for effective communication management. This query is particularly useful for maintaining and managing alert contacts within a Telegram-based notification system.

select
  id,
  friendly_name,
  type,
  status,
  value
from
  uptimerobot_alert_contact
where
  type = 18;

select
  id,
  friendly_name,
  type,
  status,
  value
from
  uptimerobot_alert_contact
where
  type = 18;

List inactive alert contacts

Identify inactive alert contacts to assess the elements within your system that may not be receiving critical notifications. This is useful for maintaining efficient communication channels and ensuring prompt responses to system alerts.

select
  id,
  friendly_name,
  type,
  status,
  value
from
  uptimerobot_alert_contact
where
  status = 0;

select
  id,
  friendly_name,
  type,
  status,
  value
from
  uptimerobot_alert_contact
where
  status = 0;

Schema for uptimerobot_alert_contact

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
friendly_name	text		Friendly name of the alert contact.
id	text	=	The ID of the alert contact.
status	bigint		The status of the alert contact. Possible values are 0 (not activated), 1 (paused), 2 (active).
type	bigint		The type of the alert contact notified. For a list of possible values, please see 'alertcontact>type' parameter in https://uptimerobot.com/api.
value	text		Alert contact's email address, phone, username, url or api key depending on the alert contact type.

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

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

steampipe_export_uptimerobot --config '<your_config>' uptimerobot_alert_contact