Hi,
We would like to have the duration of an alert.
We have follow the thread http://thwack.solarwinds.com/thread/25685 unfortunately we have an error message:
MACRO SQL ERROR - Type TIME is not a defined system type.
It seems that Time is not defined in SQL 2005.
How can we workaround this in order to have something functionnal ?
We have the number of day from
${SQL:Select Floor(Convert(float,(Convert(datetime,'${Year}-${MM}-${DD} ${HH}:${Minute}:${Second} ${AM/PM}')-Convert(datetime,'${AlertTriggerTime}'))))} days
but the second part
${SQL:Select Convert(time,Convert(datetime,'${Year}-${MM}-${DD} ${HH}:${Minute}:${Second} ${AM/PM}') - Convert(datetime,'${AlertTriggerTime}'))}
give us the error: MACRO SQL ERROR - Type TIME is not a defined system type.
Can anyone help on this ?
Cheers