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("")