All MIBs › SIEMENS-PN-MIB › hicomSQLsessionState
hicomSQLsessionState
Module: SIEMENS-PN-MIB
OID (symbolic): SIEMENS-PN-MIB::hicomSQLsessionState
OID (numeric): 1.3.6.1.4.1.231.7.2.1.8.2.1.2
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-write
Description: Indicates current state of the SQL session: idle: entry/session has been created by the agent and has to be initialized by the manager. run: to be set by the manager to initiate the execution of the SQL query. error: execution of the SQL query resulted in an error valid: execution of the SQL query was successful. Transitions: idle -> run -> {valid, error}
What is hicomSQLsessionState?
State of the SQL session: idle(1) just created, run(2) set by the manager to execute the query, error(4) the query failed, valid(5) the query succeeded. The normal transition is idle to run to valid or error.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.231.7.2.1.8.2.1.2 snmpwalk -v2c -c public <target> SIEMENS-PN-MIB::hicomSQLsessionState
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.231.7.2.1.8.2.1.2.1 snmpget -v2c -c public <target> SIEMENS-PN-MIB::hicomSQLsessionState.1
Set instance 1 (SNMPv2c):
snmpset -v2c -c private <target> 1.3.6.1.4.1.231.7.2.1.8.2.1.2.1 i <value>
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::hicomSQLsessionState 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.8 | hicomSQL | SIEMENS-PN-MIB |
| 1.3.6.1.4.1.231.7.2.1.8.2 | hicomSQLsessionTable | SIEMENS-PN-MIB |
| 1.3.6.1.4.1.231.7.2.1.8.2.1 | hicomSQLsessionEntry | SIEMENS-PN-MIB |
| 1.3.6.1.4.1.231.7.2.1.8.2.1.2 | hicomSQLsessionState | SIEMENS-PN-MIB |