8 Replies Latest reply on Mar 24, 2017 10:28 AM by Raul Gonzalez

    Filter Node for Down node more than 1 hour

    syarifuddin

      Hi All,

       

      I want to make a view of Node List (Resources: All Nodes) in Orion NPM, but only show down nodes that already down for 1 hour. So can anyone please help to build the filtering SQL?

      The only SQL I know is to filter down node "Status=2", but I still got no clue to filter the SQL for condition this 'more than 1 hour'

       

      Really appreciate for your help. Thanks a lot