All MIBs › SIEMENS-PN-MIB › hicomSQLsessionWhereClause
hicomSQLsessionWhereClause
Module: SIEMENS-PN-MIB
OID (symbolic): SIEMENS-PN-MIB::hicomSQLsessionWhereClause
OID (numeric): 1.3.6.1.4.1.231.7.2.1.8.2.1.4
Node type: OBJECT-TYPE
Type: DisplayString
Access: read-write
Description: The WHERE clause to be used for this SQL statement.
What is hicomSQLsessionWhereClause?
The WHERE clause applied to the predefined SQL statement of this session, as text. It restricts which rows the query returns.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.231.7.2.1.8.2.1.4 snmpwalk -v2c -c public <target> SIEMENS-PN-MIB::hicomSQLsessionWhereClause
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.231.7.2.1.8.2.1.4.1 snmpget -v2c -c public <target> SIEMENS-PN-MIB::hicomSQLsessionWhereClause.1
Set instance 1 (SNMPv2c):
snmpset -v2c -c private <target> 1.3.6.1.4.1.231.7.2.1.8.2.1.4.1 s <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::hicomSQLsessionWhereClause 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.4 | hicomSQLsessionWhereClause | SIEMENS-PN-MIB |