Win32_PerfRawData_DTSPipeline100 python 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_DTSPipeline100 WMI class can be used in ActiveXperts Network Monitor to monitor your servers.
Sample Code
from win32com.client import GetObject
objWMI = GetObject('winmgmts:').InstancesOf('Win32_PerfRawData_DTSPipeline100_SQLServerSSISPipeline100')
for obj in objWMI:
if obj.BLOBbytesread != None:
print("BLOBbytesread:" + str(obj.BLOBbytesread))
if obj.BLOBbyteswritten != None:
print("BLOBbyteswritten:" + str(obj.BLOBbyteswritten))
if obj.BLOBfilesinuse != None:
print("BLOBfilesinuse:" + str(obj.BLOBfilesinuse))
if obj.Buffermemory != None:
print("Buffermemory:" + str(obj.Buffermemory))
if obj.Buffersinuse != None:
print("Buffersinuse:" + str(obj.Buffersinuse))
if obj.Buffersspooled != None:
print("Buffersspooled:" + str(obj.Buffersspooled))
if obj.Caption != None:
print("Caption:" + str(obj.Caption))
if obj.Description != None:
print("Description:" + str(obj.Description))
if obj.Flatbuffermemory != None:
print("Flatbuffermemory:" + str(obj.Flatbuffermemory))
if obj.Flatbuffersinuse != None:
print("Flatbuffersinuse:" + str(obj.Flatbuffersinuse))
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.Name != None:
print("Name:" + str(obj.Name))
if obj.Privatebuffermemory != None:
print("Privatebuffermemory:" + str(obj.Privatebuffermemory))
if obj.Privatebuffersinuse != None:
print("Privatebuffersinuse:" + str(obj.Privatebuffersinuse))
if obj.Rowsread != None:
print("Rowsread:" + str(obj.Rowsread))
if obj.Rowswritten != None:
print("Rowswritten:" + str(obj.Rowswritten))
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("")
