alert id in alert message text?

nhruby

Hi,

I'd like to be able to put a unique identifier into the text of an email action from an advanced alert (either alert or reset), preferably the AlertID for the current alert from the dbo.ActiveAlerts table.  Is that possible?  I can't really select with an SQL query, because I don't have anything for the WHERE clause.

The end goal  is to send an alert to a ticketing system, and have logic on the ticketing system's side to know if the alert needs to go in a new ticket, append and old ticket, or in the case of a reset, close the ticket automaticlly.  But I need something in the alerts to key on in the ticketing system.

Anyone got a clue to spare?

KevinMcKloud

It seems like you want a 'Counter' field for each alert, if so.. Maybe I am wrong but you could try this (I haven't yet):

- In another Database of your own, create a New 'Ticket' Table with the fields you would like to have.

- Then on the Alert 'Trigger Action' add a SQL statement (using $SQL variable) to populate your new Ticket-Database-table with the Ticket-ID, incrementing it obviously.  You can use NodeID to differentiate each alert, since you can not have more than 2 open tickets for the same NodeID...mmmhh.. So maybe you will have to use another field TicketStatus for 'open', 'closed', etc.. so you can have only 1 alert TicketID with a unique NodeID with status 'open'... But you can, at the same time, have multiple TicketID's with the same NodeID  but in Status 'closed'.

- You can use NodeID, since it is unique, to now Send a 'Reset Action' email with these fields: NodeID + TicketID (just do a SQL query for NodeID in the New-Ticket-Table u just created and grab the ticketID to insert it in the email) ..  how does this sound ?  hehe.. I think I will try it!