<!-- Improved High Threshold events.  Uses translator to add DB information to high threshold events -->
    <event-translation-spec uei="uei.opennms.org/threshold/highThresholdExceeded">
      <mappings>
        <mapping>
          <assignment name="uei" type="field" >
            <value type="constant" result="uei.opennms.org/translator/highThresholdExceeded" />
          </assignment>
          <assignment name="ifDescr" type="parameter">
            <value type="sql" result="SELECT snmp.snmpIfDescr FROM snmpInterface snmp WHERE snmp.nodeid = ?::integer AND snmp.snmpifindex = ?::integer" >
              <value type="field" name="nodeid" matches=".*" result="${0}" />
              <value type="parameter" name="IfIndex" matches=".*" result="${0}" />
            </value>
          </assignment>
          <assignment name="ifName" type="parameter">
            <value type="sql" result="SELECT snmp.snmpIfName FROM snmpInterface snmp WHERE snmp.nodeid = ?::integer AND snmp.snmpifindex = ?::integer" >
              <value type="field" name="nodeid" matches=".*" result="${0}" />
              <value type="parameter" name="IfIndex" matches=".*" result="${0}" />
            </value>
          </assignment>
          <assignment name="ifAlias" type="parameter">
            <value type="sql" result="SELECT snmp.snmpIfAlias FROM snmpInterface snmp WHERE snmp.nodeid = ?::integer AND snmp.snmpifindex = ?::integer" >
              <value type="field" name="nodeid" matches=".*" result="${0}" />
              <value type="parameter" name="IfIndex" matches=".*" result="${0}" />
            </value>
          </assignment>
        </mapping>
      </mappings>
    </event-translation-spec>

    <event-translation-spec uei="uei.opennms.org/threshold/highThresholdRearmed">
      <mappings>
        <mapping>
          <assignment name="uei" type="field" >
            <value type="constant" result="uei.opennms.org/translator/highThresholdRearmed" />
          </assignment>
          <assignment name="ifDescr" type="parameter">
            <value type="sql" result="SELECT snmp.snmpIfDescr FROM snmpInterface snmp WHERE snmp.nodeid = ?::integer AND snmp.snmpifindex = ?::integer" >
              <value type="field" name="nodeid" matches=".*" result="${0}" />
              <value type="parameter" name="IfIndex" matches=".*" result="${0}" />
            </value>
          </assignment>
          <assignment name="ifName" type="parameter">
            <value type="sql" result="SELECT snmp.snmpIfName FROM snmpInterface snmp WHERE snmp.nodeid = ?::integer AND snmp.snmpifindex = ?::integer" >
              <value type="field" name="nodeid" matches=".*" result="${0}" />
              <value type="parameter" name="ifIndex" matches=".*" result="${0}" />
            </value>
          </assignment>
          <assignment name="ifAlias" type="parameter">
            <value type="sql" result="SELECT snmp.snmpIfAlias FROM snmpInterface snmp WHERE snmp.nodeid = ?::integer AND snmp.snmpifindex = ?::integer" >
              <value type="field" name="nodeid" matches=".*" result="${0}" />
              <value type="parameter" name="IfIndex" matches=".*" result="${0}" />
            </value>
          </assignment>
        </mapping>
      </mappings>
    </event-translation-spec>