[mrtg] MSSQL Server and MRTG

[Patrick Noël]

Hi

I try to use MRTG for monitoring MSSQL Server.  For example I want to
create a graph for the counter "userblocked"

when i use snmpwalk i have :

 snmpwalk -m /usr/share/snmp/mibs/MSSQL-MIB.txt sql-server .1.3.6.1.4.1.311.1.4.1.1.2.1.19
enterprises.microsoft.software.apps.mssqlServer.mssqlServerObjects.mssqlSrvInfoTable.mssqlSrvInfoEntry.mssqlSrvInfoUsersBlocked."SQL_SERVER" = Gauge32: 6

or snmpgetnext

 snmpgetnext -m /usr/share/snmp/mibs/MSSQL-MIB.txt sql-server .1.3.6.1.4.1.311.1.4.1.1.2.1.19
enterprises.microsoft.software.apps.mssqlServer.mssqlServerObjects.mssqlSrvInfoTable.mssqlSrvInfoEntry.mssqlSrvInfoUsersBlocked."SQL_SERVER" = Gauge32: 14

but with snmpget 

 snmpget -m /usr/share/snmp/mibs/MSSQL-MIB.txt sql-server .1.3.6.1.4.1.311.1.4.1.1.2.1.19
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: enterprises.microsoft.software.apps.mssqlServer.mssqlServerObjects.mssqlSrvInfoTable.mssqlSrvInfoEntry.mssqlSrvInfoUsersBlocked

snmpgetnext  sql-argus .1.3.6.1.4.1.311.1.4.1.1.2.1.19 
enterprises.311.1.4.1.1.2.1.19.9.83.81.76.95.65.82.71.85.83 = Gauge32: 8


i try with :

snmpget  sql-argus .1.3.6.1.4.1.311.1.4.1.1.2.1.19.9.83.81.76.95.65.82.71.85.83
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: enterprises.311.1.4.1.1.2.1.19.9.83.81.76.95.65.82.71.85.83

have an idea so that it reason snmpget does not work ?

how to use snmpgetnext instead of snmpget in MRTG ?

thanks

Patrick

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://lists.ee.ethz.ch/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi