Sql User Connections

[anthony.warren]

WMI = windows stuff... so you can run a tool called nsclient on windows that exposes wmi counters. Google for nsclient to find it. You install it on your windows servers, set up the nscheck scripts on your cacti / linux host - and get cacti to run the nscheck scripts to query the nsclient on the windows boxes.

Dave,

Please could you expand on what you say here as I am desperately trying to get my Linux cacti box to get info via WMI from my Windows boxes.
I have the NSClient service installed on Win2k3 box.
I can run the following:

Code: Select all

[root@beta scripts]# /bin/check_nt -H 192.168.0.2 -p 1248 -v CPULOAD -l 10,80,95                                                                                
CPU Load 13% (10 min average)

and get a sensible result.

My question is, how do I use the new WMI based templates that are being posted here, ie Win2k3 DNS queries.

Sorry if this is a dumb question!

Anthony

[ed.whitesell]

I stumbled across this thread while looking for MS SQL OIDs, and thought I might help with the other open question for how to enable SNMP support post SQL installation...

1) Add key HKLM\SOFTWARE\Microsoft\MSSQLServer\SNMP
2) Add key HKLM\SOFTWARE\Microsoft\MSSQLServer\SNMP\CurrentVersion
3) Add new string value HKLM\SOFTWARE\Microsoft\MSSQLServer\SNMP\CurrentVersion\Pathname = <MS SQL Installation Dir>\MSSQL\BINN\sqlsnmp.dll (i.e. C:\Program Files\Microsoft SQL Server\MSSQL\BINN\sqlsnmp.dll )
4) Add string value to HKLM\SYSTEM\CurrentControlSet\Services\SNMP\Parameters\ExtensionAgents
The Name of the value should be an integer one number greater than the higest existing name value. The data will be: SOFTWARE\Microsoft\MSSQLServer\SNMP\CurrentVersion

Restart the SNMP service, no need to restart SQL.

This works on Windows Server 2000 and Server 2003. It's the same process used to add any external SNMP dll to the built-in Windows SNMP service.

<>
Follow-Up: This does not work on systems that have multiple instances of SQL. I'll see if I can't figure that out though...