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, urlfrom freshping_check;
List checks in failure
select id, name, url, statusfrom freshping_checkwhere status not in ('AV', 'PS');
List checks with degraded performance
select id, name, url, statusfrom freshping_checkwhere performance_status = 'DP';
Schema for freshping_check
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
alert_contacts | jsonb | The list of contacts IDs that receive the alert. | |
alert_note | text | Troubleshooting instructions. | |
alert_users | jsonb | The list of users IDs that receive the alert. | |
basic_auth_password | text | Basic auth password. | |
basic_auth_username | text | Basic auth username. | |
command_string | text | The string to send to the tcp/udp socket. | |
error_string | text | The string to look for eror at the response for tcp/udp check. | |
id | bigint | = | Unique ID of the check. |
location | text | The monitoring location. | |
monitoring_interval | bigint | The check frequency (in seconds). | |
name | text | Name of the check. | |
performance_status | text | Performance status (GP: 'Good Performance', DP: 'Degraded Performance', AV: 'Available', PS: 'Monitoring Paused'). | |
request_timeout | bigint | The wait time for a response from the server (in seconds). | |
status | text | Status 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_string | text | The string to look for success at the response for tcp/udp check. | |
url | text | The URL to check. |