4 Replies Latest reply on Jul 10, 2015 2:07 PM by mvattem

    Database Query to link AlertLog table contents with the AuditingEvents table content

    chetz

      Hi All,

       

      I am trying to build a custom report for our NOC team to extract the alert information(mostly Historical) for any given Node in Orion from the ALertLog table (which contents the alert info that is not available to see on the console). Currently I am looking for linking the "Alert Notes" data which resides in the AuditingEvents table for each alert in the AlertLog table. Im not sure if there any key or ID that links each alert to its alert notes data (in AuditingEvents field)

       

      Any help is appreciated.

       

      Thanks,

      Chethan