Win32_PerfFormattedData_DTSPipeline100 perl 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

use Win32::OLE('in');

my $computer = ".";

my $objWMIService = Win32::OLE->GetObject("winmgmts:\\\\$computer\\root\\CIMV2") or die "WMI connection failed.\n";
my $colItems = $objWMIService->ExecQuery("SELECT * FROM Win32_PerfFormattedData_DTSPipeline100_SQLServerSSISPipeline100", "WQL");

foreach my $objItem (in $colItems) {
	print "BLOBbytesread: $objItem->{BLOBbytesread}\n";
	print "BLOBbyteswritten: $objItem->{BLOBbyteswritten}\n";
	print "BLOBfilesinuse: $objItem->{BLOBfilesinuse}\n";
	print "Buffermemory: $objItem->{Buffermemory}\n";
	print "Buffersinuse: $objItem->{Buffersinuse}\n";
	print "Buffersspooled: $objItem->{Buffersspooled}\n";
	print "Caption: $objItem->{Caption}\n";
	print "Description: $objItem->{Description}\n";
	print "Flatbuffermemory: $objItem->{Flatbuffermemory}\n";
	print "Flatbuffersinuse: $objItem->{Flatbuffersinuse}\n";
	print "Frequency_Object: $objItem->{Frequency_Object}\n";
	print "Frequency_PerfTime: $objItem->{Frequency_PerfTime}\n";
	print "Frequency_Sys100NS: $objItem->{Frequency_Sys100NS}\n";
	print "Name: $objItem->{Name}\n";
	print "Privatebuffermemory: $objItem->{Privatebuffermemory}\n";
	print "Privatebuffersinuse: $objItem->{Privatebuffersinuse}\n";
	print "Rowsread: $objItem->{Rowsread}\n";
	print "Rowswritten: $objItem->{Rowswritten}\n";
	print "Timestamp_Object: $objItem->{Timestamp_Object}\n";
	print "Timestamp_PerfTime: $objItem->{Timestamp_PerfTime}\n";
	print "Timestamp_Sys100NS: $objItem->{Timestamp_Sys100NS}\n";
	print "\n";
	print "########\n";
	print "\n";
}