SQL Server 2000 Connections via WMI

chewy009 · 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.

chewy009 · Posted: Tue Oct 25, 2005 1:02 pm Post subject:

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 · Cacti User Joined: 16 Jul 2004 Posts: 166 Location: Oregon

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 · Joined: 07 Dec 2004 Posts: 1

He did say he was running it from command line

DevilSun · Cacti User Joined: 16 Jul 2004 Posts: 166 Location: Oregon

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 · Posted: Wed Nov 09, 2005 1:48 pm Post subject:

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 · Cacti User Joined: 16 Jul 2004 Posts: 166 Location: Oregon

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 · Posted: Wed Nov 09, 2005 6:50 pm Post subject:

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 · Joined: 11 Apr 2005 Posts: 29

Hello,

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

jengstro · Cacti User Joined: 15 Nov 2005 Posts: 156

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

jengstro · Cacti User Joined: 15 Nov 2005 Posts: 156

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 · Posted: Fri Dec 02, 2005 6:13 pm Post subject:

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 · Cacti User Joined: 15 Nov 2005 Posts: 156

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

jengstro · Cacti User Joined: 15 Nov 2005 Posts: 156

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

BSOD2600 · Posted: Mon Dec 12, 2005 5:41 pm Post subject:

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