Win32_PerfRawData_MSSQLServerOLAPService jscript 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

var strComputer = ".";

var objWMIService = GetObject("winmgmts:\\\\" + strComputer + "\\root\\CIMV2");
var colItems = objWMIService.ExecQuery("SELECT * FROM Win32_PerfRawData_MSSQLServerOLAPService_MSAS2008Cache", "WQL");

var enumItems = new Enumerator(colItems);

for (; !enumItems.atEnd(); enumItems.moveNext()) {
	var objItem = enumItems.item();
	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("")
}