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';.inspect freshping_check
A check refers to the specifications configured to monitor an end-point.
| Name | Type | 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. |