MSAS2008MDX - WMI sample in VBScript

The foundations for Manageability in Windows 2019/2012/2008/ and Windows 10/8/7/Vista/XP are 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.

On this site, you can find many WMI samples.

The MSAS2008MDX WMI class can be used in ActiveXperts Network Monitor to monitor your servers.

---

MSAS2008MDX

Example(s)

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

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

For Each objItem in colItems
	WScript.Echo "Caption:" & objItem.Caption
	WScript.Echo "Currentnumberofcachedevaluationnodes:" & objItem.Currentnumberofcachedevaluationnodes
	WScript.Echo "Currentnumberofevaluationnodes:" & objItem.Currentnumberofevaluationnodes
	WScript.Echo "Description:" & objItem.Description
	WScript.Echo "Frequency_Object:" & objItem.Frequency_Object
	WScript.Echo "Frequency_PerfTime:" & objItem.Frequency_PerfTime
	WScript.Echo "Frequency_Sys100NS:" & objItem.Frequency_Sys100NS
	WScript.Echo "Name:" & objItem.Name
	WScript.Echo "Numberofbulkmodeevaluationnodes:" & objItem.Numberofbulkmodeevaluationnodes
	WScript.Echo "Numberofcachedbulkmodeevaluationnodes:" & objItem.Numberofcachedbulkmodeevaluationnodes
	WScript.Echo "Numberofcachedotherevaluationnodes:" & objItem.Numberofcachedotherevaluationnodes
	WScript.Echo "NumberofcachedStorageEngineevaluationnodes:" & objItem.NumberofcachedStorageEngineevaluationnodes
	WScript.Echo "Numberofcalculationcovers:" & objItem.Numberofcalculationcovers
	WScript.Echo "Numberofcellbycellevaluationnodes:" & objItem.Numberofcellbycellevaluationnodes
	WScript.Echo "Numberofcellbycellhitsinthecacheofevaluationnodes:" & objItem.Numberofcellbycellhitsinthecacheofevaluationnodes
	WScript.Echo "Numberofcellbycellmissesinthecacheofevaluationnodes:" & objItem.Numberofcellbycellmissesinthecacheofevaluationnodes
	WScript.Echo "Numberofevaluationnodesthatcoveredasinglecell:" & objItem.Numberofevaluationnodesthatcoveredasinglecell
	WScript.Echo "Numberofevaluationnodeswithcalculationsatthesamegranularity:" & objItem.Numberofevaluationnodeswithcalculationsatthesamegranularity
	WScript.Echo "Numberofevictionsofevaluationnodes:" & objItem.Numberofevictionsofevaluationnodes
	WScript.Echo "Numberofhashindexhitsinthecacheofevaluationnodes:" & objItem.Numberofhashindexhitsinthecacheofevaluationnodes
	WScript.Echo "NumberofStorageEngineevaluationnodes:" & objItem.NumberofStorageEngineevaluationnodes
	WScript.Echo "Numberofsubcubehitsinthecacheofevaluationnodes:" & objItem.Numberofsubcubehitsinthecacheofevaluationnodes
	WScript.Echo "Numberofsubcubemissesinthecacheofevaluationnodes:" & objItem.Numberofsubcubemissesinthecacheofevaluationnodes
	WScript.Echo "Timestamp_Object:" & objItem.Timestamp_Object
	WScript.Echo "Timestamp_PerfTime:" & objItem.Timestamp_PerfTime
	WScript.Echo "Timestamp_Sys100NS:" & objItem.Timestamp_Sys100NS
	WScript.Echo "TotalAutoexist:" & objItem.TotalAutoexist
	WScript.Echo "Totalcellscalculated:" & objItem.Totalcellscalculated
	WScript.Echo "TotalEXISTING:" & objItem.TotalEXISTING
	WScript.Echo "Totalflatcacheinserts:" & objItem.Totalflatcacheinserts
	WScript.Echo "TotalNONEMPTY:" & objItem.TotalNONEMPTY
	WScript.Echo "TotalNONEMPTYforcalculatedmembers:" & objItem.TotalNONEMPTYforcalculatedmembers
	WScript.Echo "TotalNONEMPTYunoptimized:" & objItem.TotalNONEMPTYunoptimized
	WScript.Echo "Totalrecomputes:" & objItem.Totalrecomputes
	WScript.Echo "TotalSonarsubcubes:" & objItem.TotalSonarsubcubes
	WScript.Echo ""
	WScript.Echo "########"
	WScript.Echo ""
Next