Win32_PerfRawData_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_PerfRawData_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_PerfRawData_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
}
