sensu-go-sql-select-count-check

Table of Contents

• Overview
• Files
• Usage examples
• Configuration
  • Asset registration
  • Check definition
• Installation from source
• Additional notes
• Contributing

Overview

The sensu-go-sql-select-count-check is a Sensu Check that query SQL DB and check first column of the first row against thresholds.

Files

Usage examples

Configuration

Asset registration

Sensu Assets are the best way to make use of this plugin. If you're not using an asset, please consider doing so! If you're using sensuctl 5.13 with Sensu Backend 5.13 or later, you can use the following command to add the asset:

sensuctl asset add sardinasystems/sensu-go-sql-select-count-check

If you're using an earlier version of sensuctl, you can find the asset on the [Bonsai Asset Index][https://bonsai.sensu.io/assets/sardinasystems/sensu-go-sql-select-count-check].

Check definition

---
type: CheckConfig
api_version: core/v2
metadata:
  name: sensu-go-sql-select-count-check
  namespace: default
spec:
  command: >-
    sensu-go-sql-select-count-check
    --dburl mysql://foo:bar@localhost:3306/test
    --query 'SELECT COUNT(*) FROM table WHERE type = ? AND state = ?;' -a sometype -a somestate
  subscriptions:
    - system
  runtime_assets:
    - sardinasystems/sensu-go-sql-select-count-check

Installation from source

The preferred way of installing and deploying this plugin is to use it as an Asset. If you would like to compile and install the plugin from source or contribute to it, download the latest version or create an executable script from this source.

From the local path of the sensu-go-sql-select-count-check repository:

go build

Additional notes

Contributing

For more information about contributing to this plugin, see Contributing.