[ First - *please* don't mail me privately, without copying
any responses to the mailing list. I don't have the time
or inclination to offer private, unpaid, SNMP consultancy.
Keep discussions to the list, where others can both learn
and offer advice. That will also reduce the risk of such a
long delay before coming across an unanswered query.
Thanks. ]
2009/2/5 malar vizhi <malar...@gmail.com>:
> And Dave, Can you plzz tell me that, does MS
> SQL Server 2005 supports SNMP?
I have no idea.
That's not anything to do with the Net-SNMP project.
You would need to ask Microsoft (or look in the
relevant documentation)
> Consider mssql.mib, there is one table called "mssqlSrvConfigParamTable".
> this table contains
> 5 rows. Then these each row have multiple row values.
>
> mssqlSrvConfigParamTable : 1.3.6.1.4.1.311.1.4.1.1.3 (table Oid)
> mssqlSrvConfigParamName : 1.3.6.1.4.1.311.1.4.1.1.3.1.1(first row id of the
> above table)
>
> And this above row have multiple values..If i execute snmpwalk command
> for the above row ID am able to get all the sub rows. But If I execute getnext
> command with " 1.3.6.1.4.1.311.1.4.1.1.3.1.1.1" am getting the same result
> "locks". I want to access each sub row individually...How to do that?
Your query doesn't really make much sense.
As far as I can tell, the mssqlSrvConfigParamTable contains five columns
(although the MIB file I can find seems to be somewhat malformed)
The number of rows will depend on how the SQL server is configured,
with one row for each configured parameter.
snmpwalk ... 1.3.6.1.4.1.311.1.4.1.1.3.1.1
would walk through the list of parameters.
snmpget .... 1.3.6.1.4.1.311.1.4.1.1.3.1.1.\"someParameter\"
(i.e. snmpget ... mssqlSrvConfigParamName.\"someParameter\")
would retrieve the name of that parameter.
More usefully:
snmpget .... 1.3.6.1.4.1.311.1.4.1.1.3.1.5.\"someParameter\"
would retrieve the current value of this paramater
(i.e. mssqlSrvConfigParamRunValue)
If that's not what you meant (and the problem is still present),
then you're going to need to be a bit more specific.
Dave
------------------------------------------------------------------------------
_______________________________________________
Net-snmp-users mailing list
Net-snmp-users@lists.sourceforge.net
Please see the following page to unsubscribe or change other options:
https://lists.sourceforge.net/lists/listinfo/net-snmp-users
