WMI SQL 2005 class waitstatistics

[RonyA]

Hello
i try to graph the object Lockwaits on a MSSQL server 2005 by WMI ( http://forums.cacti.net/about30438.html )

I have made a new data template and when i deploy the graph i have error in cacti log file :

08/18/2009 04:30:19 PM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1064', Message:'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'attente_moyen_(ms) Lockwaits1:0 Name1:Attentes_en_cours Lockwaits2:0 Name2:Atten' at line 1', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (400,'','2009-08-18 16:30:06','Buffercachehitratio:1854 Buffercachehitratio_Base:1856'),(402,'BatchRequestsPersec','2009-08-18 16:30:06','BatchRequestsPersec:46087722'),(403,'Transactions','2009-08-18 16:30:06','Transactions:20'),(406,'','2009-08-18 16:30:06','Buffercachehitratio:1684 Buffercachehitratio_Base:1686'),(410,'ram_total','2009-08-18 16:30:06','2146697216'),(410,'ram','2009-08-18 16:30:06','1792016384'),(414,'','2009-08-18 16:30:06','AnonymousUsersPersec:7426 ConnectionAttemptsPersec:7351 CurrentAnonymousUsers:0 CurrentConnections:0 CurrentNonAnonymousUsers:0 LogonAttemptsPersec:7426 Name:_Total NonAnonymousUsersPersec:0'),(415,'','2009-08-18 16:30:06','CopyRequestsPersec:0 DeleteRequestsPersec:0 GetRequestsPersec:7426 HeadRequestsPersec:0 LockRequestsPersec:0 MkcolRequestsPersec:0 MoveRequestsPersec:0 Name:_Total OptionsRequestsPersec:0 OtherRequestMethodsPersec:0 PostRequestsPersec:0 PropfindRequestsPersec:0 ProppatchReques'


when i execute the script

/usr/bin/php -q /home/sites_web/cacti-server/scripts/wmi.php -h 'IP' -u '/etc/cacti/cactiwmi.pw' -w 'Win32_PerfRawData_MSSQLSERVER_SQLServerWaitstatistics' -n '' -k '' -v '' -c 'Lockwaits' -d1


/home/sites_web/cacti-server/scripts/wmic --namespace='root\CIMV2' --authentication-file=/etc/cacti/cactiwmi.pw //IP "SELECT Lockwaits FROM Win32_PerfRawData_MSSQLSERVER_SQLServerWaitstatistics"
Exec Status: 0

Lockwaits0:0
Name0:Temps_d'attente_moyen_(ms)
Lockwaits1:0
Name1:Attentes_en_cours
Lockwaits2:0
Name2:Attentes_dÃmarrÃes_par_seconde
Lockwaits3:0
Name3:Temps_d'attente_cumulÃ_(ms)_par_seconde

I have the value of Lockwaits


it is there an option in wmic to filter the value Lockwaits0

thank you in advance

regards

[shazinaz]

Thank you so much for these info.