Contact Info

Crumbtrail

ActiveXperts.com » Administration » Scripts » WMI » vbscript sample

Win32_PerfRawData_MSSQLServerOLAPService vbscript sample code

The foundations for Manageability in Windows is Windows Management Instrumentation (WMI; formerly WBEM) and WMI extensions for Windows Driver Model (WDM).

ActiveXperts Network Monitor provides the ability to build monitor check routines based on WMI. ActiveXperts has collected more than a hundred WMI samples. You can use these samples as a base for new check routines you can write yourself. The Win32_PerfRawData_MSSQLServerOLAPService WMI class can be used in ActiveXperts Network Monitor to monitor your servers.


Sample Code

Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")

Set colItems = objWMIService.ExecQuery("Select * From Win32_PerfRawData_MSSQLServerOLAPService_MSAS2008Cache")

For Each objItem in colItems
	WScript.Echo "Caption:" & objItem.Caption
	WScript.Echo "Currententries:" & objItem.Currententries
	WScript.Echo "CurrentKB:" & objItem.CurrentKB
	WScript.Echo "Description:" & objItem.Description
	WScript.Echo "Directhitratio:" & objItem.Directhitratio
	WScript.Echo "Directhitratio_Base:" & objItem.Directhitratio_Base
	WScript.Echo "DirecthitsPersec:" & objItem.DirecthitsPersec
	WScript.Echo "EvictionsPersec:" & objItem.EvictionsPersec
	WScript.Echo "Frequency_Object:" & objItem.Frequency_Object
	WScript.Echo "Frequency_PerfTime:" & objItem.Frequency_PerfTime
	WScript.Echo "Frequency_Sys100NS:" & objItem.Frequency_Sys100NS
	WScript.Echo "InsertsPersec:" & objItem.InsertsPersec
	WScript.Echo "KBaddedPersec:" & objItem.KBaddedPersec
	WScript.Echo "LookupsPersec:" & objItem.LookupsPersec
	WScript.Echo "MissesPersec:" & objItem.MissesPersec
	WScript.Echo "Name:" & objItem.Name
	WScript.Echo "Timestamp_Object:" & objItem.Timestamp_Object
	WScript.Echo "Timestamp_PerfTime:" & objItem.Timestamp_PerfTime
	WScript.Echo "Timestamp_Sys100NS:" & objItem.Timestamp_Sys100NS
	WScript.Echo "Totaldirecthits:" & objItem.Totaldirecthits
	WScript.Echo "Totalevictions:" & objItem.Totalevictions
	WScript.Echo "Totalfilterediteratorcachehits:" & objItem.Totalfilterediteratorcachehits
	WScript.Echo "Totalfilterediteratorcachemisses:" & objItem.Totalfilterediteratorcachemisses
	WScript.Echo "Totalinserts:" & objItem.Totalinserts
	WScript.Echo "Totallookups:" & objItem.Totallookups
	WScript.Echo "Totalmisses:" & objItem.Totalmisses
	WScript.Echo ""
	WScript.Echo "########"
	WScript.Echo ""
Next