Search code examples
geneos

Date comparision in Geneos

I have a requirement where I need to compare start time with current time and if the value is greater than certain limit I need an alerting. Can someone share the syntax.

Ex:

I have a column called start time with below syntax.

Start Time >> 2015-12-03 15:04:02.0

I want to put a rule like

if (now()-value) > 3600 then severity critical

THis syntax doesn't work, can someone pls help

Solution

  • You will need to make your value from string to Date first.

    Use this :

    set $(dateValue) parseDate('%Y-%m-%d %H:%M:%S.%f', value)
if (now()- $(dateValue)) > 3600 then 
  severity critical
endif

    You may want to read the detail for parseDate function from the "Gateway2 Reference Guide.pdf" document.