Tips from a serverscheck user

We successfully use serverscheck to monitor our process controlroom network with 190 active monitors including snmp reads and network maps. We found that the documentaion about odbc logging is a bit confusing, but finally got it working.

We use Microsoft MS SQL server 9.0.4053 and configured the tables accoring the file sql.sql found in the add-ons directory.

However with the following differences:

The Table SERVERSCHECK has the field UUID, the others have UID,

The table SERVERSCHECK also has Groups and Types fields varchar(50)

We also found out that the SERVERSCHECK_DATA table is growing even if the option 'Store data values' is NOT set.

Also the valuetype field in the SERVERSCHECK_DATA is only set with the WindowsHealth monitor, with other monitors, ik keeps null.

Unfortunately, the field type, in the table SERVERSCHECK_CHECKS is showing the monitor type, not the device type.



Despite these issues, its working and useful, we use the product Qlikview to visualize statistics like Service level.



To have a monthly reset of the values including the service level, a batchfile is scheduled to run. it will:

-net stop servicechecks

-delete all dat files in the servercheck_monitoringdata directory

-run a freeware tool to connect to the SQL database and execute 3 SQL commands:

delete from serverscheck

delete from serverscheck_checks

delete from serverscheck_data

-net start servicechecks



The freeware tool for the sql commands is

sqlrun.exe from sqledit.com



screenshots of our serverscheck installation:



http://imageshack.us/photo/my-images/12/example1wz.jpg/



http://imageshack.us/photo/my-images/685/example2wx.jpg/

Thank you for the valuable feedback. We will add it to our wiki

A question i still have:

-How is the service level calculated per monitor

-How is the groups service level calculated ?



Thanks

Marcel

2 ways you can do it:

- either based on downtime compared to uptime

- or based on number of down checks compared to up checks



- group service level is the sum of the service levels of all group members divided by the number of checks in the group.

ok thank you, i was referring to the calculated service levels i see on the monitors and the group page.

So that means that with the monitors, its probably based on downtime compared to uptime.



(So the calculations in serverscheck)