Contact Info

Crumbtrail » Administration » Scripts » WMI » vbscript sample

Win32_PerfRawData_DTSPipeline100 vbscript 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

Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")

Set colItems = objWMIService.ExecQuery("Select * From Win32_PerfRawData_DTSPipeline100_SQLServerSSISPipeline100")

For Each objItem in colItems
	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 ""