Win32_PerfFormattedData_WRTCESPf 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_WRTCESPf 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_WRTCESPf_LCUSrv00DBStore", "WQL");

foreach my $objItem (in $colItems) {
	print "Caption: $objItem->{Caption}\n";
	print "Description: $objItem->{Description}\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 "Timestamp_Object: $objItem->{Timestamp_Object}\n";
	print "Timestamp_PerfTime: $objItem->{Timestamp_PerfTime}\n";
	print "Timestamp_Sys100NS: $objItem->{Timestamp_Sys100NS}\n";
	print "USrv000QueueDepth: $objItem->{USrv000QueueDepth}\n";
	print "USrv002QueueLatencymsec: $objItem->{USrv002QueueLatencymsec}\n";
	print "USrv004SprocLatencymsec: $objItem->{USrv004SprocLatencymsec}\n";
	print "USrv006PercentDatabaseTime: $objItem->{USrv006PercentDatabaseTime}\n";
	print "USrv008ThreadsWaitingforNewDatabaseRequests: $objItem->{USrv008ThreadsWaitingforNewDatabaseRequests}\n";
	print "USrv009ThreadsExecutingDatabaseOperations: $objItem->{USrv009ThreadsExecutingDatabaseOperations}\n";
	print "USrv010ThreadsCallingBackwithDatabaseResults: $objItem->{USrv010ThreadsCallingBackwithDatabaseResults}\n";
	print "USrv011BlockedClientThreads: $objItem->{USrv011BlockedClientThreads}\n";
	print "USrv013TotalDeadlocks: $objItem->{USrv013TotalDeadlocks}\n";
	print "USrv014TotalDroppedRequests: $objItem->{USrv014TotalDroppedRequests}\n";
	print "USrv015TotalDeadlockFailures: $objItem->{USrv015TotalDeadlockFailures}\n";
	print "USrv016TotalTransactionCountMismatchFailures: $objItem->{USrv016TotalTransactionCountMismatchFailures}\n";
	print "USrv017TotalODBCTimeoutFailures: $objItem->{USrv017TotalODBCTimeoutFailures}\n";
	print "USrv018TotalsevereSQLerrors: $objItem->{USrv018TotalsevereSQLerrors}\n";
	print "USrv019TotalfatalSQLerrors: $objItem->{USrv019TotalfatalSQLerrors}\n";
	print "USrv020ThrottledrequestsPersec: $objItem->{USrv020ThrottledrequestsPersec}\n";
	print "USrv021Totalthrottledrequests: $objItem->{USrv021Totalthrottledrequests}\n";
	print "\n";
	print "########\n";
	print "\n";
}