Win32_PerfFormattedData_WRTCESPf 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_WRTCESPf 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_WRTCESPf_LCUSrv00DBStore"

foreach ($obj in $objWmi)
{
	write-host "Caption:" $obj.Caption
	write-host "Description:" $obj.Description
	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 "Timestamp_Object:" $obj.Timestamp_Object
	write-host "Timestamp_PerfTime:" $obj.Timestamp_PerfTime
	write-host "Timestamp_Sys100NS:" $obj.Timestamp_Sys100NS
	write-host "USrv000QueueDepth:" $obj.USrv000QueueDepth
	write-host "USrv002QueueLatencymsec:" $obj.USrv002QueueLatencymsec
	write-host "USrv004SprocLatencymsec:" $obj.USrv004SprocLatencymsec
	write-host "USrv006PercentDatabaseTime:" $obj.USrv006PercentDatabaseTime
	write-host "USrv008ThreadsWaitingforNewDatabaseRequests:" $obj.USrv008ThreadsWaitingforNewDatabaseRequests
	write-host "USrv009ThreadsExecutingDatabaseOperations:" $obj.USrv009ThreadsExecutingDatabaseOperations
	write-host "USrv010ThreadsCallingBackwithDatabaseResults:" $obj.USrv010ThreadsCallingBackwithDatabaseResults
	write-host "USrv011BlockedClientThreads:" $obj.USrv011BlockedClientThreads
	write-host "USrv013TotalDeadlocks:" $obj.USrv013TotalDeadlocks
	write-host "USrv014TotalDroppedRequests:" $obj.USrv014TotalDroppedRequests
	write-host "USrv015TotalDeadlockFailures:" $obj.USrv015TotalDeadlockFailures
	write-host "USrv016TotalTransactionCountMismatchFailures:" $obj.USrv016TotalTransactionCountMismatchFailures
	write-host "USrv017TotalODBCTimeoutFailures:" $obj.USrv017TotalODBCTimeoutFailures
	write-host "USrv018TotalsevereSQLerrors:" $obj.USrv018TotalsevereSQLerrors
	write-host "USrv019TotalfatalSQLerrors:" $obj.USrv019TotalfatalSQLerrors
	write-host "USrv020ThrottledrequestsPersec:" $obj.USrv020ThrottledrequestsPersec
	write-host "USrv021Totalthrottledrequests:" $obj.USrv021Totalthrottledrequests
	write-host
	write-host "########"
	write-host
}