Home > Uncategorized > Centreon query for historic check submissions and alerts

Centreon query for historic check submissions and alerts

Centreon is the Nagios front end I use.  It has some nice features, and is a good rolled-up version of Nagios.

This query will return records that contain a given string (“fnTrapMemThreshold”) in the output field (this is really the returned info to the nagios fifo I think).

SELECT FROM_UNIXTIME(ctime), output FROM centstorage."log" WHERE FROM_UNIXTIME(ctime) >= '20110926114300' AND FROM_UNIXTIME(ctime) <= '20110926114559' AND output LIKE '%fnTrapMemThreshold%' ORDER BY FROM_UNIXTIME(ctime);

Quite useful when your firewall is blowing up, sending about forty “memory threshold is hit” traps per minute, you can disable notifications, and just run this query later to show some proof that your firewall vendor has some of the worst QA managers around.  I’m talking to you, Fortinet!  You release bug riddled firmware!  You hear that?!  Why???

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: