Alert Notes are blank in Acknowledged Alert Message when using the Acknowledge URL

marunderwood

I setup an alert to send an email when another alert (I'll refer to this as the original alert) has been acknowledged.  However, in the email, the Notes are blank.  I'm using:

${SQL: Select top 1 substring(notes,16,200) from alertstatus where activeobject = ${nodeid} and acknowledged <> 0 order by acknowledgedtime desc}

I'm also using the AcknowledgeURL variable in the original alert to acknowledge the alert.

When the original alert message is sent & I click on the link, the current date/time is automatically populated and the acknowledged flag is set immediately.  I don't even have time to type a Note before the 'Acknowledged Alert' email arrives, so of course it is blank.  Is there something in the setup I can change to delay the update until I enter a note and 'save' it?

p.s.  I could delay the 'Acknowledge Alert' for a little while, but I have it set to trigger this alert if it was acknowledged within 2 minutes.  If it takes someone longer than 2 minutes to type the note, it  won't work for that scenario.  To solve that, I could increase the 2 minutes, but if 2 alerts are acknowledged within that time frame, only one will be reported.

p.s.s.  I guess one option is to NOT use the AcknowledgeURL.  Any other ideas?

marunderwood

After running some more tests without using the AcknowledgeURL (I just went to the alert page of the web console), I was able to get the note to come out.  I changed the substring in the SQL stmt to start in position 1 (instead of 16) because depending on how I enter the text, it's either prefixed with the word 'Acknowledged:' or not.  Below are my test results for 3 scenarios (the test results contain the path I used to enter the text):

Test #1 -

Acknowledged:checked box, clicked button, then keyed the note

Test #2 -

clicked alert name and keyed the note first
Acknowledged:then keyed another note after checking the box and clicking the button.

Test #3 -

just keyed after clicking the alert name, then clicked the check box & didn't enter a note the 2nd time.