Skip to content

Instantly share code, notes, and snippets.

@ajohnstone

ajohnstone/gist:4046661

Created November 9, 2012 16:26
Show Gist options
  • Save ajohnstone/4046661 to your computer and use it in GitHub Desktop.
Save ajohnstone/4046661 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> SELECT * FROM icinga_conninfo;
+-------------+-------------+------------------------+---------------+-------------+----------------+--------------+---------------------+---------------------+---------------------+---------------------+---------------------+-----------------+-----------------+-------------------+
| conninfo_id | instance_id | agent_name | agent_version | disposition | connect_source | connect_type | connect_time | disconnect_time | last_checkin_time | data_start_time | data_end_time | bytes_processed | lines_processed | entries_processed |
+-------------+-------------+------------------------+---------------+-------------+----------------+--------------+---------------------+---------------------+---------------------+---------------------+---------------------+-----------------+-----------------+-------------------+
| 1 | 1 | IDOMOD | 1.7.1 | REALTIME | TCPSOCKET | INITIAL | 2012-11-09 16:03:47 | 0000-00-00 00:00:00 | 2012-11-09 16:25:22 | 2012-11-09 16:03:47 | 0000-00-00 00:00:00 | 2692126 | 259654 | 5579 |
| 2 | 1 | IDO2DB Trimming Thread | 1.7.1 | REALTIME | TCPSOCKET | INITIAL | 2012-11-09 16:08:47 | 0000-00-00 00:00:00 | 2012-11-09 16:08:47 | 2012-11-09 16:08:47 | 0000-00-00 00:00:00 | 0 | 0 | 0 |
+-------------+-------------+------------------------+---------------+-------------+----------------+--------------+---------------------+---------------------+---------------------+---------------------+---------------------+-----------------+-----------------+-------------------+
2 rows in set (0.02 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment