Table: uptimerobot_maintenance_window - Query UptimeRobot Maintenance Windows using SQL

UptimeRobot is a website monitoring service that checks your website's availability at regular intervals. Maintenance Windows in UptimeRobot represent scheduled periods of downtime for maintenance on monitored websites or services. These windows allow for planned interruptions in service without impacting uptime statistics.

Table Usage Guide

The uptimerobot_maintenance_window table provides insights into Maintenance Windows within UptimeRobot. As a site reliability engineer or DevOps professional, you can explore details about scheduled maintenance periods through this table, including start and end times, duration, and affected monitors. Utilize it to plan and track maintenance activities, ensuring minimal disruption to your services and preserving the accuracy of your uptime statistics.

Examples

Basic info

Explore which maintenance windows are currently active on your UptimeRobot account. This is useful for understanding when your website or service may be temporarily unavailable due to scheduled maintenance.

select
  id,
  user,
  friendly_name,
  start_time
from
  uptimerobot_maintenance_window;

select
  id,
  user,
  friendly_name,
  start_time
from
  uptimerobot_maintenance_window;

List paused maintenance windows

Discover the segments that have paused maintenance windows, allowing you to assess the elements within your system that may need attention or rescheduling. This is useful for understanding the current operational status and planning future maintenance activities.

select
  id,
  friendly_name,
  status
from
  uptimerobot_maintenance_window
where
  status = 0;

select
  id,
  friendly_name,
  status
from
  uptimerobot_maintenance_window
where
  status = 0;

List maintenance windows with duration longer than than 60 minutes

Discover the segments that have maintenance windows extending beyond an hour. This information can be useful for identifying potential periods of downtime or service interruptions.

select
  id,
  friendly_name,
  duration
from
  uptimerobot_maintenance_window
where
  duration > 60;

select
  id,
  friendly_name,
  duration
from
  uptimerobot_maintenance_window
where
  duration > 60;

List maintenance windows that are checked on daily basis

Discover the segments that undergo daily maintenance checks, helping you to understand the frequency and duration of these routine operations. This can assist in scheduling tasks and avoiding potential disruptions.

select
  id,
  friendly_name,
  duration
from
  uptimerobot_maintenance_window
where
  type = 2;

select
  id,
  friendly_name,
  duration
from
  uptimerobot_maintenance_window
where
  type = 2;

Schema for uptimerobot_maintenance_window

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
duration	bigint	=	Duration of the maintenance windows in minutes.
friendly_name	text		Friendly name of the maintenance window.
id	bigint		The ID of the maintenance window.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
start_time	text		Start time of the maintenance window.
status	bigint		Status of the maintenance window. Possible values are 0 (paused), 1 (active).
type	bigint	=	Type of the maintenance window. Possible values are 1 (Once), 2 (Daily), 3 (Weekly), 4 (Monthly).
user	bigint		User of the maintenance window.
user_id	text	=, !=, ~~, ~~, !~~, !~~	User ID of the account.
value	text		Separated with '-' and used only for weekly and monthly maintenance windows.

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_maintenance_window