Win32_PerfFormattedData_DTSPipeline100 jscript 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
var strComputer = "."; var objWMIService = GetObject("winmgmts:\\\\" + strComputer + "\\root\\CIMV2"); var colItems = objWMIService.ExecQuery("SELECT * FROM Win32_PerfFormattedData_DTSPipeline100_SQLServerSSISPipeline100", "WQL"); var enumItems = new Enumerator(colItems); for (; !enumItems.atEnd(); enumItems.moveNext()) { var objItem = enumItems.item(); WScript.Echo("BLOBbytesread: " + objItem.BLOBbytesread); WScript.Echo("BLOBbyteswritten: " + objItem.BLOBbyteswritten); WScript.Echo("BLOBfilesinuse: " + objItem.BLOBfilesinuse); WScript.Echo("Buffermemory: " + objItem.Buffermemory); WScript.Echo("Buffersinuse: " + objItem.Buffersinuse); WScript.Echo("Buffersspooled: " + objItem.Buffersspooled); WScript.Echo("Caption: " + objItem.Caption); WScript.Echo("Description: " + objItem.Description); WScript.Echo("Flatbuffermemory: " + objItem.Flatbuffermemory); WScript.Echo("Flatbuffersinuse: " + objItem.Flatbuffersinuse); WScript.Echo("Frequency_Object: " + objItem.Frequency_Object); WScript.Echo("Frequency_PerfTime: " + objItem.Frequency_PerfTime); WScript.Echo("Frequency_Sys100NS: " + objItem.Frequency_Sys100NS); WScript.Echo("Name: " + objItem.Name); WScript.Echo("Privatebuffermemory: " + objItem.Privatebuffermemory); WScript.Echo("Privatebuffersinuse: " + objItem.Privatebuffersinuse); WScript.Echo("Rowsread: " + objItem.Rowsread); WScript.Echo("Rowswritten: " + objItem.Rowswritten); WScript.Echo("Timestamp_Object: " + objItem.Timestamp_Object); WScript.Echo("Timestamp_PerfTime: " + objItem.Timestamp_PerfTime); WScript.Echo("Timestamp_Sys100NS: " + objItem.Timestamp_Sys100NS); WScript.Echo("") WScript.Echo("########") WScript.Echo("") }