Contact Info

Crumbtrail

ActiveXperts.com » Administration » Scripts » WMI » powershell sample

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
}