All MIBs › MSSQLSERVER-MIB › mssqlSrvConfigParamConfigValue
mssqlSrvConfigParamConfigValue
Module: MSSQLSERVER-MIB
OID (symbolic): MSSQLSERVER-MIB::mssqlSrvConfigParamConfigValue
OID (numeric): 1.3.6.1.4.1.311.1.4.1.1.3.1.4
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: The current configured value for the associated SQL Server configuration parameter.
What is mssqlSrvConfigParamConfigValue?
This read-only OID reports the configured value currently stored for this parameter, which may differ from the value actually in effect (see mssqlSrvConfigParamRunValue) until SQL Server is reconfigured or restarted.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.311.1.4.1.1.3.1.4 snmpwalk -v2c -c public <target> MSSQLSERVER-MIB::mssqlSrvConfigParamConfigValue
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.311.1.4.1.1.3.1.4.1 snmpget -v2c -c public <target> MSSQLSERVER-MIB::mssqlSrvConfigParamConfigValue.1
SNMPv3 example:
snmpget -v3 -l authPriv -u snmpv3-user -a SHA -A "AuthPassword1" -x AES -X "PrivPassword1" <target> mssqlSrvConfigParamConfigValue.1
Start monitoring Windows servers running Microsoft SQL Server with a free 30-day trial of IPNetwork Monitor. Create custom SNMP monitor using the MSSQLSERVER-MIB::mssqlSrvConfigParamConfigValue OID value, configure state conditions and alerts, and monitor any Windows servers running Microsoft SQL Server from a single console.
OID Breakdown
Upper-level ancestors (8 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.311 | microsoft | InternetServer-MIB |
| 1.3.6.1.4.1.311.1 | software | InternetServer-MIB |
| Numeric OID | Name | Module |
|---|---|---|
| 1.3.6.1.4.1.311.1.4 | apps | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1 | mssqlServer | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1.1 | mssqlServerObjects | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1.1.3 | mssqlSrvConfigParamTable | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1.1.3.1 | mssqlSrvConfigParamEntry | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1.1.3.1.4 | mssqlSrvConfigParamConfigValue | MSSQLSERVER-MIB |