Contact Info

Crumbtrail

ActiveXperts.com » Administration » Scripts » WMI Performance Counters » Python

MSAS2008Memory - WMI sample in Python

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 MSAS2008Memory WMI class can be used in ActiveXperts Network Monitor to monitor your servers.


MSAS2008Memory

Example(s)

from win32com.client import GetObject
objWMI = GetObject('winmgmts:').InstancesOf('Win32_PerfRawData_MSSQLServerOLAPService_MSAS2008Memory')

for obj in objWMI:
	if obj.AggCacheKB != None:
		print("AggCacheKB:" + str(obj.AggCacheKB))
	if obj.AggregationMapFiles != None:
		print("AggregationMapFiles:" + str(obj.AggregationMapFiles))
	if obj.Caption != None:
		print("Caption:" + str(obj.Caption))
	if obj.CleanerBalancePersec != None:
		print("CleanerBalancePersec:" + str(obj.CleanerBalancePersec))
	if obj.CleanerCurrentPrice != None:
		print("CleanerCurrentPrice:" + str(obj.CleanerCurrentPrice))
	if obj.CleanerMemoryKB != None:
		print("CleanerMemoryKB:" + str(obj.CleanerMemoryKB))
	if obj.CleanerMemorynonshrinkableKB != None:
		print("CleanerMemorynonshrinkableKB:" + str(obj.CleanerMemorynonshrinkableKB))
	if obj.CleanerMemoryshrinkableKB != None:
		print("CleanerMemoryshrinkableKB:" + str(obj.CleanerMemoryshrinkableKB))
	if obj.CleanerMemoryshrunkKBPersec != None:
		print("CleanerMemoryshrunkKBPersec:" + str(obj.CleanerMemoryshrunkKBPersec))
	if obj.Description != None:
		print("Description:" + str(obj.Description))
	if obj.DimensionIndexHashFiles != None:
		print("DimensionIndexHashFiles:" + str(obj.DimensionIndexHashFiles))
	if obj.DimensionPropertyFiles != None:
		print("DimensionPropertyFiles:" + str(obj.DimensionPropertyFiles))
	if obj.DimensionStringFiles != None:
		print("DimensionStringFiles:" + str(obj.DimensionStringFiles))
	if obj.FactAggregationFiles != None:
		print("FactAggregationFiles:" + str(obj.FactAggregationFiles))
	if obj.FactDataFiles != None:
		print("FactDataFiles:" + str(obj.FactDataFiles))
	if obj.FactStringFiles != None:
		print("FactStringFiles:" + str(obj.FactStringFiles))
	if obj.FilestoreClockPagesExaminedPersec != None:
		print("FilestoreClockPagesExaminedPersec:" + str(obj.FilestoreClockPagesExaminedPersec))
	if obj.FilestoreClockPagesHaveRefPersec != None:
		print("FilestoreClockPagesHaveRefPersec:" + str(obj.FilestoreClockPagesHaveRefPersec))
	if obj.FilestoreClockPagesValidPersec != None:
		print("FilestoreClockPagesValidPersec:" + str(obj.FilestoreClockPagesValidPersec))
	if obj.FilestoreIOErrors != None:
		print("FilestoreIOErrors:" + str(obj.FilestoreIOErrors))
	if obj.FilestoreIOErrorsPersec != None:
		print("FilestoreIOErrorsPersec:" + str(obj.FilestoreIOErrorsPersec))
	if obj.FilestoreKB != None:
		print("FilestoreKB:" + str(obj.FilestoreKB))
	if obj.FilestoreKBReadsPersec != None:
		print("FilestoreKBReadsPersec:" + str(obj.FilestoreKBReadsPersec))
	if obj.FilestoreKBWritePersec != None:
		print("FilestoreKBWritePersec:" + str(obj.FilestoreKBWritePersec))
	if obj.FilestoreMemoryPinnedKB != None:
		print("FilestoreMemoryPinnedKB:" + str(obj.FilestoreMemoryPinnedKB))
	if obj.FilestorePageFaultsPersec != None:
		print("FilestorePageFaultsPersec:" + str(obj.FilestorePageFaultsPersec))
	if obj.FilestoreReadsPersec != None:
		print("FilestoreReadsPersec:" + str(obj.FilestoreReadsPersec))
	if obj.FilestoreWritesPersec != None:
		print("FilestoreWritesPersec:" + str(obj.FilestoreWritesPersec))
	if obj.Frequency_Object != None:
		print("Frequency_Object:" + str(obj.Frequency_Object))
	if obj.Frequency_PerfTime != None:
		print("Frequency_PerfTime:" + str(obj.Frequency_PerfTime))
	if obj.Frequency_Sys100NS != None:
		print("Frequency_Sys100NS:" + str(obj.Frequency_Sys100NS))
	if obj.InmemoryAggregationMapFileKB != None:
		print("InmemoryAggregationMapFileKB:" + str(obj.InmemoryAggregationMapFileKB))
	if obj.InmemoryAggregationMapFileKBPersec != None:
		print("InmemoryAggregationMapFileKBPersec:" + str(obj.InmemoryAggregationMapFileKBPersec))
	if obj.InmemoryDimensionIndexHashFileKB != None:
		print("InmemoryDimensionIndexHashFileKB:" + str(obj.InmemoryDimensionIndexHashFileKB))
	if obj.InmemoryDimensionIndexHashFileKBPersec != None:
		print("InmemoryDimensionIndexHashFileKBPersec:" + str(obj.InmemoryDimensionIndexHashFileKBPersec))
	if obj.InmemoryDimensionPropertyFileKB != None:
		print("InmemoryDimensionPropertyFileKB:" + str(obj.InmemoryDimensionPropertyFileKB))
	if obj.InmemoryDimensionPropertyFileKBPersec != None:
		print("InmemoryDimensionPropertyFileKBPersec:" + str(obj.InmemoryDimensionPropertyFileKBPersec))
	if obj.InmemoryDimensionStringFileKB != None:
		print("InmemoryDimensionStringFileKB:" + str(obj.InmemoryDimensionStringFileKB))
	if obj.InmemoryDimensionStringFileKBPersec != None:
		print("InmemoryDimensionStringFileKBPersec:" + str(obj.InmemoryDimensionStringFileKBPersec))
	if obj.InmemoryFactAggregationFileKB != None:
		print("InmemoryFactAggregationFileKB:" + str(obj.InmemoryFactAggregationFileKB))
	if obj.InmemoryFactAggregationFileKBPersec != None:
		print("InmemoryFactAggregationFileKBPersec:" + str(obj.InmemoryFactAggregationFileKBPersec))
	if obj.InmemoryFactDataFileKB != None:
		print("InmemoryFactDataFileKB:" + str(obj.InmemoryFactDataFileKB))
	if obj.InmemoryFactDataFileKBPersec != None:
		print("InmemoryFactDataFileKBPersec:" + str(obj.InmemoryFactDataFileKBPersec))
	if obj.InmemoryFactStringFileKB != None:
		print("InmemoryFactStringFileKB:" + str(obj.InmemoryFactStringFileKB))
	if obj.InmemoryFactStringFileKBPersec != None:
		print("InmemoryFactStringFileKBPersec:" + str(obj.InmemoryFactStringFileKBPersec))
	if obj.InmemoryMapFileKB != None:
		print("InmemoryMapFileKB:" + str(obj.InmemoryMapFileKB))
	if obj.InmemoryMapFileKBPersec != None:
		print("InmemoryMapFileKBPersec:" + str(obj.InmemoryMapFileKBPersec))
	if obj.InmemoryOtherFileKB != None:
		print("InmemoryOtherFileKB:" + str(obj.InmemoryOtherFileKB))
	if obj.InmemoryOtherFileKBPersec != None:
		print("InmemoryOtherFileKBPersec:" + str(obj.InmemoryOtherFileKBPersec))
	if obj.MapFiles != None:
		print("MapFiles:" + str(obj.MapFiles))
	if obj.MemoryLimitHighKB != None:
		print("MemoryLimitHighKB:" + str(obj.MemoryLimitHighKB))
	if obj.MemoryLimitLowKB != None:
		print("MemoryLimitLowKB:" + str(obj.MemoryLimitLowKB))
	if obj.MemoryUsageKB != None:
		print("MemoryUsageKB:" + str(obj.MemoryUsageKB))
	if obj.Name != None:
		print("Name:" + str(obj.Name))
	if obj.OtherFiles != None:
		print("OtherFiles:" + str(obj.OtherFiles))
	if obj.PagePool1AllocKB != None:
		print("PagePool1AllocKB:" + str(obj.PagePool1AllocKB))
	if obj.PagePool1LookasideKB != None:
		print("PagePool1LookasideKB:" + str(obj.PagePool1LookasideKB))
	if obj.PagePool64AllocKB != None:
		print("PagePool64AllocKB:" + str(obj.PagePool64AllocKB))
	if obj.PagePool64LookasideKB != None:
		print("PagePool64LookasideKB:" + str(obj.PagePool64LookasideKB))
	if obj.PagePool8AllocKB != None:
		print("PagePool8AllocKB:" + str(obj.PagePool8AllocKB))
	if obj.PagePool8LookasideKB != None:
		print("PagePool8LookasideKB:" + str(obj.PagePool8LookasideKB))
	if obj.PotentialInmemoryAggregationMapFileKB != None:
		print("PotentialInmemoryAggregationMapFileKB:" + str(obj.PotentialInmemoryAggregationMapFileKB))
	if obj.PotentialInmemoryDimensionIndexHashFileKB != None:
		print("PotentialInmemoryDimensionIndexHashFileKB:" + str(obj.PotentialInmemoryDimensionIndexHashFileKB))
	if obj.PotentialInmemoryDimensionPropertyFileKB != None:
		print("PotentialInmemoryDimensionPropertyFileKB:" + str(obj.PotentialInmemoryDimensionPropertyFileKB))
	if obj.PotentialInmemoryDimensionStringFileKB != None:
		print("PotentialInmemoryDimensionStringFileKB:" + str(obj.PotentialInmemoryDimensionStringFileKB))
	if obj.PotentialInmemoryFactAggregationFileKB != None:
		print("PotentialInmemoryFactAggregationFileKB:" + str(obj.PotentialInmemoryFactAggregationFileKB))
	if obj.PotentialInmemoryFactDataFileKB != None:
		print("PotentialInmemoryFactDataFileKB:" + str(obj.PotentialInmemoryFactDataFileKB))
	if obj.PotentialInmemoryFactStringFileKB != None:
		print("PotentialInmemoryFactStringFileKB:" + str(obj.PotentialInmemoryFactStringFileKB))
	if obj.PotentialInmemoryMapFileKB != None:
		print("PotentialInmemoryMapFileKB:" + str(obj.PotentialInmemoryMapFileKB))
	if obj.PotentialInmemoryOtherFileKB != None:
		print("PotentialInmemoryOtherFileKB:" + str(obj.PotentialInmemoryOtherFileKB))
	if obj.QuotaBlocked != None:
		print("QuotaBlocked:" + str(obj.QuotaBlocked))
	if obj.QuotaKB != None:
		print("QuotaKB:" + str(obj.QuotaKB))
	if obj.Timestamp_Object != None:
		print("Timestamp_Object:" + str(obj.Timestamp_Object))
	if obj.Timestamp_PerfTime != None:
		print("Timestamp_PerfTime:" + str(obj.Timestamp_PerfTime))
	if obj.Timestamp_Sys100NS != None:
		print("Timestamp_Sys100NS:" + str(obj.Timestamp_Sys100NS))
	print("")
	print("########")
	print("")