KS-Soft

HM 11.98
Action type - SQL Query
Query is "Insert into [SensorDB].[dbo].[ThermoEvents] (DeviceId, Value) VALUES ('%CommentLine1%', '%Reply%')"
ODBC is ODBC Driver for Microsoft SQL Server, version 06.01.7601
OS is win 2008r2 SP1
antivirus monitoring is absent

Hi! We buy Advanced license then install program and enter registration code in program (Advanced Host Monitor ver. 11.98) But unfortunately action profile which add record to an SQL server (SQL Query) does not work. In system log we can see error: “Action "SQL Query" cannot be performed...

KS-Soft Europe wrote:In such case expression should look like the following:
('%SimpleStatus%'=='DOWN') and (%PreviousStatusDuration_Sec%+%CurrentStatusDuration_sec% < 1800)

Works great! Thank you!

Could you make some examples to explain what you need? Example1: 10:00:00 TestItem01 Status: Ok 10:20:00 TestItem01 Status: Bad <No Action should be triggered> 10:40:00 TestItem01 Status: Ok 10:45:00 TestItem01 Status: Bad <Start Action/Alert> In this example between current bad and last Ok status ...

As I understand you correctly, you need to use expression like the following: ('%SimpleStatus%'=='DOWN') and ('%CurrentStatusDuration%' < '00:30:00') This is not exactly what i need. For example - test going down then up. If after that test going down within 30 minutes then i need trigger an action.

Hi! I want to start action based on time difference between test previous status change and current status change time. For example i need to set snmp value if time difference last status change and current status time is less than 30 minutes. I try to use expression: ('%SimpleStatus%'=='DOWN') and ...