Win32_PerfFormattedData_DTSPipeline100 powershell 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_PerfFormattedData_DTSPipeline100 WMI class can be used in ActiveXperts Network Monitor to monitor your servers.
Sample Code
$strComputer = "." $objWMi = get-wmiobject -computername localhost -Namespace root\CIMV2 -Query "Select * from Win32_PerfFormattedData_DTSPipeline100_SQLServerSSISPipeline100" foreach ($obj in $objWmi) { write-host "BLOBbytesread:" $obj.BLOBbytesread write-host "BLOBbyteswritten:" $obj.BLOBbyteswritten write-host "BLOBfilesinuse:" $obj.BLOBfilesinuse write-host "Buffermemory:" $obj.Buffermemory write-host "Buffersinuse:" $obj.Buffersinuse write-host "Buffersspooled:" $obj.Buffersspooled write-host "Caption:" $obj.Caption write-host "Description:" $obj.Description write-host "Flatbuffermemory:" $obj.Flatbuffermemory write-host "Flatbuffersinuse:" $obj.Flatbuffersinuse write-host "Frequency_Object:" $obj.Frequency_Object write-host "Frequency_PerfTime:" $obj.Frequency_PerfTime write-host "Frequency_Sys100NS:" $obj.Frequency_Sys100NS write-host "Name:" $obj.Name write-host "Privatebuffermemory:" $obj.Privatebuffermemory write-host "Privatebuffersinuse:" $obj.Privatebuffersinuse write-host "Rowsread:" $obj.Rowsread write-host "Rowswritten:" $obj.Rowswritten write-host "Timestamp_Object:" $obj.Timestamp_Object write-host "Timestamp_PerfTime:" $obj.Timestamp_PerfTime write-host "Timestamp_Sys100NS:" $obj.Timestamp_Sys100NS write-host write-host "########" write-host }