dblxAdmin - 2015-01-29

The HEYMon team want to introduce HEYMonSQL (HMSQL). HMSQL is Structured Query Language (SQL) for systems and application monitoring.
HMSQL will allow an administrator to execute SQL commands which tell HEYMon to perform monitoring jobs.
An example of a SQL request to check for a running process on the server MyServer looks like this in HMSQL:

 SELECT RESPONSE FROM WebView WHERE EXPECTEDRESPONSE='_ID-7861455' AND TIMEOUTSECS=5 AND SERVERADDRESS='http://www.website.con/path1/contact.html' AND SERVERNAME='My Web Site' AND EXTERNALSITE='http://www.yahoo.com'

This SQL command will return details about whether the web page is available, took too long to respond, or generated an error.

HMSQL works with most of the HEYMon Job types, and will eventually be extended for use as a management portal where HMSQL can be used to check on configured jobs and recent alerts.

Download HEYMonSQL and take it for a spin!

 

Last edit: dblxAdmin 2015-03-13