All MIBs › SIEMENS-PN-MIB › hicomSQLsessionFinished

hicomSQLsessionFinished

OID (symbolic): SIEMENS-PN-MIB::hicomSQLsessionFinished

OID (numeric): 1.3.6.1.4.1.231.7.2.1.21.2.8.20

Node type: NOTIFICATION-TYPE

Description: A hicomSQLsessionFinished trap indicates the completion of an SQL query. If hicomSQLsessionState indicates an error in the query, hicomSQLsessionResultLines will contain the SQL error code instead of the number of resulting lines. In this case, no entry in the hicomSQLresultTable will be created.

Examples

Send this trap to an SNMP manager — replace <manager> with the IP or hostname of your monitoring server (SNMPv2c):

snmptrap -v2c -c public <manager> '' SIEMENS-PN-MIB::hicomSQLsessionFinished
snmptrap -v2c -c public <manager> '' 1.3.6.1.4.1.231.7.2.1.21.2.8.20

Listen for incoming traps on the manager host (-f keeps it in the foreground, -Lo prints to stdout — useful for testing):

snmptrapd -f -Lo -c /dev/null authCommunity log public

Example snmptrapd log entry:

zoo11-linux.zoo [UDP: [192.168.30.111]:57274->[192.168.30.10]:162]:
  DISMAN-EVENT-MIB::sysUpTimeInstance = Timeticks: (61140410) 7 days, 1:50:04.10
  SNMPv2-MIB::snmpTrapOID.0 = OID: SIEMENS-PN-MIB::hicomSQLsessionFinished

SNMPv3 example:

snmptrap -v3 -l authPriv -u snmpv3user -a SHA -A "AuthPass1" -x AES -X "PrivPass1" <manager> '' SIEMENS-PN-MIB::hicomSQLsessionFinished

Start monitoring Siemens Hicom 300 PBX, Siemens UNITY telephony system (topology/alarm/system-change status) with a free 30-day trial of IPNetwork Monitor. Create custom SNMP monitor using the SIEMENS-PN-MIB::hicomSQLsessionFinished OID value, configure state conditions and alerts, and monitor any Siemens Hicom 300 PBX, Siemens UNITY telephony system (topology/alarm/system-change status) from a single console.

OID Breakdown

Upper-level ancestors (9 from the standard OID tree / other modules)

Numeric OID	Name	Module
1	iso	LANART-AGENT
1.3	org	AirPair-MIB
1.3.6	dod	AirPair-MIB
1.3.6.1	internet	AirPair-MIB
1.3.6.1.4	private	AirPair-MIB
1.3.6.1.4.1	enterprises	AirPair-MIB
1.3.6.1.4.1.231	sni	AN-MIB
1.3.6.1.4.1.231.7	siemensUnits	AN-MIB
1.3.6.1.4.1.231.7.2	pn	H150E-MIB

Numeric OID	Name	Module
1.3.6.1.4.1.231.7.2.1	hicomMib	SIEMENS-PN-MIB
1.3.6.1.4.1.231.7.2.1.21	hicomTrapGroup	SIEMENS-PN-MIB
1.3.6.1.4.1.231.7.2.1.21.2	hicomTraps	SIEMENS-PN-MIB
1.3.6.1.4.1.231.7.2.1.21.2.8	hicomSQLTraps	SIEMENS-PN-MIB
1.3.6.1.4.1.231.7.2.1.21.2.8.20	hicomSQLsessionFinished	SIEMENS-PN-MIB

SIEMENS-PN-MIB :: hicomSQLsessionFinished

hicomSQLsessionFinished

Module

This MIB depends on