Comparing 2 ODBC tests

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
Vincent
Posts: 1
Joined: Tue Jun 27, 2006 1:47 pm

Comparing 2 ODBC tests

Post by Vincent »

Hi,

I just downloaded the Host Monitor 6.02 Beta for testing.
There is one crucial test that I can not figure out.

I have two ODBC Query’s to compare.

Master has a reply of VF0625
Shop1 has a reply of VF0622
Shop2 has a reply of VF0625
How can I make the Shop 1 test go Bad and Shop 2 test go Ok.

Master, Shop1 and Shop2 only execute a SQL query

I made 2 extra tests:

Test1 is a copy of Shop1 with Expression
('%::Master::Status%'=='%::Shop1::Status%') and ('%::Master::Reply%'<>'%::Shop1::Reply%')
This gives a Ok result and should be Bad

Test2 is a copy of Shop2 with Expression
('%::Master::Status%'=='%::Shop2::Status%') and ('%::Master::Reply%'<>'%::Shop2::Reply%')
This gives a Wait for Master and should be Ok

I hope some one can help me.
Vincent
KS-Soft
Posts: 13012
Joined: Wed Apr 03, 2002 6:00 pm
Location: USA
Contact:

Post by KS-Soft »

'%::Master::Status%'=='%::Shop1::Status%') and ('%::Master::Reply%'<>'%::Shop1::Reply%')
This gives a Ok result and should be Bad
This expression does not give you any result. Expression tells HostMonitor when test should be performed.
If a logical expression returns "false" value, HostMonitor will not perform the dependant test.
This gives a Wait for Master and should be Ok
If you do not want to see WaitForMaster status, use "Synchronize status & alerts" option.
See also: OtherwiseStatus option

Regards
Alex
Post Reply