steampipe plugin install francois2metz/freshping

Table: freshping_check

In Freshping, a Check refers to the specifications configured to monitor an end-point. Checks can be performed for (HTTP/ HTTPS, ICMP ping, UDP, TCP, WebSocket, DNS)

Examples

List all checks

select
id,
name,
url
from
freshping_check;

List checks in failure

select
id,
name,
url,
status
from
freshping_check
where
status not in ('AV', 'PS');

List checks with degraded performance

select
id,
name,
url,
status
from
freshping_check
where
performance_status = 'DP';

Schema for freshping_check

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
alert_contactsjsonbThe list of contacts IDs that receive the alert.
alert_notetextTroubleshooting instructions.
alert_usersjsonbThe list of users IDs that receive the alert.
basic_auth_passwordtextBasic auth password.
basic_auth_usernametextBasic auth username.
command_stringtextThe string to send to the tcp/udp socket.
error_stringtextThe string to look for eror at the response for tcp/udp check.
idbigint=Unique ID of the check.
locationtextThe monitoring location.
monitoring_intervalbigintThe check frequency (in seconds).
nametextName of the check.
performance_statustextPerformance status (GP: 'Good Performance', DP: 'Degraded Performance', AV: 'Available', PS: 'Monitoring Paused').
request_timeoutbigintThe wait time for a response from the server (in seconds).
statustextStatus of the check (AV: 'Available', NR: 'Not Responding', RE: 'Reporting Error', PS: 'Monitoring Paused', DME: 'DNS Record Matching Failure', SME: 'String Check Matching Failure', SCE: 'Status Code check Failure').
success_stringtextThe string to look for success at the response for tcp/udp check.
urltextThe URL to check.