Test if RMA is alive before testing

plambrecht · Post by **plambrecht** » Mon Mar 14, 2005 4:04 am

Hi Alex,

What is the best way to check that an RMA is alive ?
For now I just use PING to see if the wanIP is ok..
I want to use the TCP test, so that I can really check the RMA itself.
Do you have any suggestions on the 'send data' and 'expected reply' ?

Also, it would be great that there was an option to not perform tests if the RMA is unavailble... Now I just disble all tests in the folder and subfolders when the RMA is unavailable..

Pieter

KS-Soft · Post by **KS-Soft** » Mon Mar 14, 2005 6:17 pm

What is the best way to check that an RMA is alive ?

I think simple TCP test (without "Send data" option) is good enough.

Also, it would be great that there was an option to not perform tests if the RMA is unavailble... Now I just disble all tests in the folder and subfolders when the RMA is unavailable..

I have another idea - implement posibility to use primary and backup agent.

Regards
Alex

plambrecht · Post by **plambrecht** » Tue Mar 15, 2005 2:08 am

Also an option...
But most of RMA's are connected over the internet.. so if the clients ADSL line is down, I won't have much use of a backup RMA

P.

KS-Soft · Post by **KS-Soft** » Tue Mar 15, 2005 5:31 pm

Yes, it will not help in such case.
But why you disable tests when agent unavailable? for better performance? for statistical purpose?

Regards
Alex

plambrecht · Post by **plambrecht** » Wed Mar 16, 2005 3:02 am

I was in the idea that if the RMA is down, all tests return an Unknown.
This means that info without meaning is logged in my reporting database (advanced logging, odbc log)
I would like to keep that to a minimum...

Maybe a nice option would to limit the data that is logged to the odbc...
for ex an expression that is entered ('%StatusID%'=='07') and if the result is true, then the SQL query is executed...

more advanced: different sql query's based on an expression...
for ex BAD&OK run a query; unknown&disabled run another query, ...

Just a thought when I was typing...

*** Forget all about the above ***
I just saw that 5.10 is out... you already implemented it !

thx

P.

KS-Soft · Post by **KS-Soft** » Wed Mar 16, 2005 1:18 pm

Yes, version 5.10 has new "Record HM Log" action method.
However if you are usign ODBC log, you may use "SQL Query" action (implemented in version 3.00)

Regards
Alex

plambrecht · Post by **plambrecht** » Thu Mar 17, 2005 2:13 am

I'm using the SQL query (advanced logging)...
the only problem was that I only want OK and BAD statusses logged in my SQL database...
This new action solves the problem partialy...
I had to add it to every test.. little bit time consuming...

So I looked further and I discovered that SQL also supports the "IF" statement...

So now I'm not using the new action but this SQL statement:

Code: Select all

IF (('%StatusID%'='08') OR ('%StatusID%'='07')) begin <insert into code> end

works really great !

P.

KS-Soft · Post by **KS-Soft** » Thu Mar 17, 2005 1:06 pm

I'm using the SQL query (advanced logging)...
the only problem was that I only want OK and BAD statusses logged in my SQL database...

I understand. But "SQL Query" action method was implemented long time ago in version 3 (there is "advanced logging" option and there is "SQL Query" action).

So I looked further and I discovered that SQL also supports the "IF" statement...
IF (('%StatusID'='08') OR ('%StatusID'='07')) begin <insert into code> end

Cool. I didn't think about that

Regards
Alex