We run an inhouse help desk system. We already have procedures in place to create tickets using a MSSQL sql stored procedure.
I have written a database trigger that will generate the ticket from the alarm table and update the hd_ticket field in the alarm table. It is possible to make that ticket number appear in the GUI?