6 Replies Latest reply on Jun 13, 2017 6:38 AM by uniswtc

    Alert rule trigger condition - Need as SQL query

    uniswtc

      Hi,


      We are using NPM 11.5.2 and SAM 6.2.2. I wrote an alert rule to get the WAN link bandwidth utilization. We have some sites start with ES- (EMEA region) and this region has 50+ sites. I would like to use a condition as "Nodes Custom Properties - UIS_Location - starts with - ES-". I was not able to use this condition, as it shows the values to select from the drop down list. I would like to have SQL query for the below trigger conditions, it would be easy for me to create rules for other regions also. Or, is there an option to use the mentioned condition, if we change the attributes of the custom property for the parameter UIS_Location. So that, it would allow to select the list value or a static value as "Starts with" - "ES-". Please advise.

       

       

      Trigger Condition:  

      All child conditions must be satisfied (AND)
        Nodes Custom Properties - UIS_DevType - is equal to - RTR
        Nodes Custom Properties - UIS_Managed - is equal to - 1
        Node - Node Name - does not contain - ATT_ANIRA
        At least one child condition must be satisfied (OR)
        Nodes Custom Properties - UIS_Location - is equal to - ES-AJH1
        Nodes Custom Properties - UIS_Location - is equal to - ES-COJ
        Nodes Custom Properties - UIS_Location - is equal to - ES-CTS
        Nodes Custom Properties - UIS_Location - is equal to - ES-DHM
        Nodes Custom Properties - UIS_Location - is equal to - ES-GRI1
        Nodes Custom Properties - UIS_Location - is equal to - ES-LPA
        Nodes Custom Properties - UIS_Location - is equal to - ES-PAD
        Nodes Custom Properties - UIS_Location - is equal to - ES-LLE2
        Nodes Custom Properties - UIS_Location - is equal to - ES-TUD
        Nodes Custom Properties - UIS_Location - is equal to - ES-ZEF
        At least one child condition must be satisfied (OR)
        Interface - Caption - contains - Link to PE
        Interface - Caption - contains - MPLS PE
        Interface - Caption - starts with - Multilink
        At least one child condition must be satisfied (OR)
        Interface - Transmit Percent Utilization - is greater than - 90
        Interface - Received Percent Utilization - is greater than - 90

       

      Thanks,

      Naren.