DX Infrastructure Manager

Expand all | Collapse all

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

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

    Posted 09-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 09-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




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

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