[Xymon] Creating Java Monitor for Xymon

[Jeremy Laidman]

Foster

On what OS are you running your Java monitor?

I can think of a few different ways to do this type of thing.  Firstly, you
could use the Java Socket() function to connect to the Xymon server(s) and
send a "BB" format message.

Secondly, you could use some kind of wrapper script or batch file that runs
the Java program, and then performs the socket connection to send the raw
"BB" message.

Thirdly, you could use a wrapper or batch file to run the Java program, and
then run a Xymon client program to send the message.

Cheers
Jeremy

On Thu, Feb 18, 2016 at 7:00 AM Foster Patch <Foster.Patch at accuweather.com>
wrote:

> Hello, I have created a Java Program that will pull a date from a stored
> procedure in a SQL Server, which then is compared to the current date, and
> will alarm red if it is past the threshold. Thus far, I have developed the
> code independent of Xymon, but now plan on implementing it since it is
> functioning properly. Below is my java code. Instead of printing out “Uh
> oh” if the date is older than 2 hours, I would like to make it alarm on the
> servers page. I don’t know where to begin from here, and any suggestions or
> pointers in the right direction would be great. Additionally, any examples
> of using Java as a monitor in Xymon would be very beneficial. I plan on
> storing this in \ext\trunk\monitor.d\120.
>
> *package* connect;
>
> *import* java.sql.DriverManager;
> *import* java.sql.CallableStatement;
> *import* java.sql.Connection;
> *import* java.sql.ResultSet;
> *import* java.sql.SQLException;
> *import* *java.text.DateFormat*;
> *import* *java.text.SimpleDateFormat*;
> *import* java.util.Calendar;
> *import* java.util.Date;
>
>
> *public* *class* Sqlselection {
>
>         *public* *static* *void* main(String[] args) *throws*
> SQLException, ClassNotFoundException {
>                 CallableStatement callableStatement = *null*;
>
>
>                 Class.*forName*(
> "com.microsoft.sqlserver.jdbc.SQLServerDriver");
>                 Connection conn = DriverManager.*getConnection*(
> "jdbc:sqlserver://sqldev-v02.accu.accuwx.com
> ;database=analysis_summary;integratedSecurity=true;");
>                 String getCall = "{call
> proc_Return_Latest_AirQuality_DateTime}";
>
>                 callableStatement = conn.prepareCall(getCall);
>
>                 ResultSet rs = callableStatement.executeQuery();
>
>                 *while* (rs.next()) {
>                         String delims = "[.]+";
>                         String seconddelim = "[- :]+";
>                                 String columnValue = rs.getString(1);
>                                 String[] tokens = columnValue.split(delims
> );
>
>                                 String checkTime[] = tokens[0].split(
> seconddelim);
>
>                                 *int* year = Integer.*parseInt*(checkTime
> [0]);
>                                 *int* month = Integer.*parseInt*(checkTime
> [1]);
>                                 *int* day = Integer.*parseInt*(checkTime
> [2]);
>                                 *int* hour = Integer.*parseInt*(checkTime
> [3]);
>                                 *int* minute = Integer.*parseInt*(
> checkTime[4]);
>                                 *int* second = Integer.*parseInt*(
> checkTime[5]);
>
>                                 Calendar cal = Calendar.*getInstance*();
>                                 Date todayDate = *new* Date();
>
>                                 todayDate = cal.getTime();
>
>
>                                 Date checkDate = *new* Date();
>                                 checkDate.*setYear**(**year**-1900)*;
>                                 checkDate.*setMonth**(**month**)*;
>                                 checkDate.*setDate**(**day**)*;
>                                 checkDate.*setHours**(**hour**)*;
>                                 checkDate.*setMinutes**(**minute**)*;
>                                 checkDate.*setSeconds**(**second**)*;
>
>                                 todayDate.*setHours**(**todayDate**.*
> *getHours**()-2)*;
>
>                                 *if*(checkDate.before(todayDate)){
>                                         System.*out*.println("UH OH");
>                                 }
>                                 *else* *if*(checkDate.after(todayDate)){
>                                         System.*out*.println("yep");
>                                 }
>                         }
>         }
> }
>
> Foster Patch
> Web Server Technician
> AccuWeather
> 385 Science Park Road, State College, PA 16803
> P: 814.235.8650
> E: *Foster.Patch at accuweather.com* <Foster.Patch at accuweather.com>
> E: *networkoperations at accuweather.com* <networkoperations at accuweather.com>
> *http://www.AccuWeather.com* <http://www.accuweather.com/>
>
>
>
> _______________________________________________
> Xymon mailing list
> Xymon at xymon.com
> http://lists.xymon.com/mailman/listinfo/xymon
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20160224/23949dcd/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Picture (Device Independent Bitmap) 1.jpg
Type: image/jpeg
Size: 753 bytes
Desc: not available
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20160224/23949dcd/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Picture (Device Independent Bitmap) 1.jpg
Type: image/jpeg
Size: 753 bytes
Desc: not available
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20160224/23949dcd/attachment-0001.jpg>