SQL Server 2000 Connections via WMI

[chewy009]

I am trying to get this to work on a W2k/SQL2k box but am getting the following error when I run the script from the CMD line:

Check the computer and class name.
No information was found on the specified class!

The cacti log says this:

10/11/2005 10:09:56 AM - CACTID: Poller[0] Host[59] DS[554] SCRIPT: perl D:\Apache2\htdocs\cacti/scripts/w32_sql_query_connections.pl SQLServer get UserConnections,LoginsPersec,LogoutsPersec, output: U
10/11/2005 10:09:56 AM - CACTID: Poller[0] Host[59] DS[554] WARNING: Result from SCRIPT not valid. Partial Result: ...

I ran winmgmt /resyncperf from the cmd line as well with no luck.

Any help would be appreciated.

[chewy009]

Anyone have any ideas on my previous post? Still being dogged by the boss on this.

Thanks in advance for any help!!!

Posted: Tue Oct 11, 2005 12:12 pm Post subject:

--------------------------------------------------------------------------------

I am trying to get this to work on a W2k/SQL2k box but am getting the following error when I run the script from the CMD line:

Check the computer and class name.
No information was found on the specified class!

The cacti log says this:

10/11/2005 10:09:56 AM - CACTID: Poller[0] Host[59] DS[554] SCRIPT: perl D:\Apache2\htdocs\cacti/scripts/w32_sql_query_connections.pl SQLServer get UserConnections,LoginsPersec,LogoutsPersec, output: U
10/11/2005 10:09:56 AM - CACTID: Poller[0] Host[59] DS[554] WARNING: Result from SCRIPT not valid. Partial Result: ...

I ran winmgmt /resyncperf from the cmd line as well with no luck.

Any help would be appreciated.

[DevilSun]

Turn output on to "DEBUG" for once cycle, and post what the actual response is.

"Partial Response:..." doesn't help much...

Or, even better, run the query from the command line

[quastr]

He did say he was running it from command line

but am getting the following error when I run the script from the CMD line:

Check the computer and class name.
No information was found on the specified class!

I am also getting this error. Does anything else need to be installed on the mssql box?

[DevilSun]

Well, if you're sure WMI is up and running and it's not firewall or permissions related, I'd suggest using Microsoft's WMI Tools (Link) to browse to the computer and browse through the classes to see if it's there on your box. Also, don't forget about "wmiadap /f" to force WMI to update itself.

[chewy009]

I've downloaded the WMI Tool but can't seem to find what I am looking for. Does anyone know what the instance is and where to find it. I am new to WMI. Thanks.

[DevilSun]

Use the WMI Object Browser. When it opens and says "Connect to namespace:", click the Icon next to the drop down list to browse for a namespace. Change the machine name to the remote machine, and click Connect, open "root" and highlight "CIMV2" and press "OK". When you do that successfully, it'll connect to "\\<remotemachine>\root\CIMV2". Now click the binocular button to find a class -- you'll get a TON of classes returned -- you're looking for a class called "Win32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics", the problem however is the box list isn't wide enough to see the full classes...but you should have quite a few that start with "Win32_PerfFormattedData_MSSQLSERVER...", if you have none, the SQL WMI classes didn't get registered or something, and you probably need to run "wmiadap /f" to fix it.

[chewy009]

OK, so i got it working. I am assuming DevilSun ( ) that you are running SQL 2000 on Wk3 server. I am running SQL2000 on W2k server, which has a different class. Modified the class in the script to be "Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics" and it started working right away.

Thanks again for your help!

[cactus_jack]

Hello,

I am getting the following results from my install, I am using cacti on Redhat to monitor a windows server.

Code: Select all

11/14/2005 01:25:21 PM - CMDPHP: Poller[0] Host[21] DS[920] CMD: perl /var/www/cacti/scripts/nt_perfmon.pl uhdadw09.uhd.campus "\\SQLServer:General Statistics\User Connections", output: U  
11/14/2005 01:25:21 PM - CMDPHP: Poller[0] Host[21] DS[920] WARNING: Result from CMD not valid. Partial Result:  

If anyone could shed some light as to what i need to do that would be greatly appreciated.

Vince

[jengstro]

Any time I hit the binocular button the thing locks up... any ideas?

[jengstro]

Ok... after a few trys... it came up and there are around 15 or so mssql items there. But when I run the script from a command line as the user used above, it cannot pull the information.

It complains that it cant talk to the WMI server.

I should also mention that I can pull processor data via WMI...

[BSOD2600]

If your running the cacti scheduled task with the SYSTEM user account, this would be the cause of the problem. You need to use a real user account or specify a username/password in your WMI script(s).

[jengstro]

I am using a domain created account that has been added to the local adminisrators group on the server and client machines.

[jengstro]

This user does not require any access to the SQL database itself I would assume?

[BSOD2600]

I haven't looked at the script, but I doubt not since this is being done via WMI.