Table: uptimerobot_account - Query UptimeRobot Accounts using SQL

UptimeRobot is a service that performs website checks to determine their uptime and functionality. It can monitor different types of internet services, including HTTP, HTTPS, SMTP, POP3, and IMAP. UptimeRobot can send alerts about downtime and other technical issues.

Table Usage Guide

The uptimerobot_account table provides insights into the UptimeRobot account settings. As a Site Reliability Engineer (SRE), you can use this table to access account-specific details, including the type of monitoring checks, alert contacts, and monitor intervals. Utilize it to review and manage the monitoring settings and ensure the smooth operation of your internet services.

Examples

Basic info

Analyze the settings to understand the limits and intervals of your uptime monitors, as well as identify the users associated with each monitor. This is beneficial for managing resources and ensuring optimal monitoring performance.

select
  email,
  user_id,
  monitor_limit,
  monitor_interval,
  up_monitors
from
  uptimerobot_account;

select
  email,
  user_id,
  monitor_limit,
  monitor_interval,
  up_monitors
from
  uptimerobot_account;

Get monitor limits of the account

Explore the limitations and intervals for monitoring within your account. This can help you understand and manage your account's monitoring capacity and frequency.

select
  email,
  user_id,
  monitor_limit,
  monitor_interval
from
  uptimerobot_account;

select
  email,
  user_id,
  monitor_limit,
  monitor_interval
from
  uptimerobot_account;

List up, down, and paused monitors in the account

Determine the status of your monitors across your account by identifying which ones are active, inactive, or paused. This can help you manage your resources effectively by focusing your attention on monitors that require immediate action.

select
  email,
  user_id,
  up_monitors,
  down_monitors,
  paused_monitors
from
  uptimerobot_account;

select
  email,
  user_id,
  up_monitors,
  down_monitors,
  paused_monitors
from
  uptimerobot_account;

Schema for uptimerobot_account

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
down_monitors	bigint		The number of down monitors.
email	text		The account e-mail.
first_name	text		First name with which the account is registered.
monitor_interval	bigint		The min monitoring interval (in seconds) supported by the account.
monitor_limit	bigint		The max number of monitors that can be created for the account.
paused_monitors	bigint		The number of paused monitors.
sms_credits	bigint		The SMS credits limit of the account.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
total_monitors_count	bigint		Total number of monitors running.
up_monitors	bigint		The number of up monitors.
user_id	bigint	=, !=, ~~, ~~, !~~, !~~	User ID of the account.

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_account