DX Unified Infrastructure Management

  • Private Community
 View Only

  • 1.  Obtain when an alarm it's open or close on historical

    Posted Sep 10, 2021 04:20 PM
    Hi everyone.

    For create a report i need obtain when an alarm it's open or close, I am working from this table nas_transaction_summary.
    In IM I see that this field exist but in nas_transaction_summary not.

    I need this field.



    What can I do ?


  • 2.  RE: Obtain when an alarm it's open or close on historical

    Posted Sep 13, 2021 07:55 AM
    If I understand correctly, you want the field 'closed' - this will be null until closed.


    I also believe that you can get this from nas_transaction_log where type=16


    Original Message


  • 3.  RE: Obtain when an alarm it's open or close on historical

    Posted Sep 17, 2021 07:59 PM
    Thanks Garin, I used the field 'closed' with a sentence 'CASE' on  my query.
    Original Message