LCUSrv03SubPresenceSQLcalls - WMI sample in VBScript

The foundations for Manageability in Windows 2019/2012/2008/ and Windows 10/8/7/Vista/XP are 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.

On this site, you can find many WMI samples.

The LCUSrv03SubPresenceSQLcalls WMI class can be used in ActiveXperts Network Monitor to monitor your servers.

---

LCUSrv03SubPresenceSQLcalls

Example(s)

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

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

For Each objItem in colItems
	WScript.Echo "Caption:" & objItem.Caption
	WScript.Echo "Description:" & objItem.Description
	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 "Timestamp_Object:" & objItem.Timestamp_Object
	WScript.Echo "Timestamp_PerfTime:" & objItem.Timestamp_PerfTime
	WScript.Echo "Timestamp_Sys100NS:" & objItem.Timestamp_Sys100NS
	WScript.Echo "USrv000SproccallsPerSec:" & objItem.USrv000SproccallsPerSec
	WScript.Echo "USrv001SprocLatencymsec:" & objItem.USrv001SprocLatencymsec
	WScript.Echo "USrv003Numberofcalls:" & objItem.USrv003Numberofcalls
	WScript.Echo "USrv004BSubCreatecallsPerSec:" & objItem.USrv004BSubCreatecallsPerSec
	WScript.Echo "USrv005BSubCreatecallLatency:" & objItem.USrv005BSubCreatecallLatency
	WScript.Echo "USrv007NumberofBSubCreatecalls:" & objItem.USrv007NumberofBSubCreatecalls
	WScript.Echo "USrv008BSubAddcallsPerSec:" & objItem.USrv008BSubAddcallsPerSec
	WScript.Echo "USrv009BSubAddcallLatency:" & objItem.USrv009BSubAddcallLatency
	WScript.Echo "USrv011NumberofBSubAddcalls:" & objItem.USrv011NumberofBSubAddcalls
	WScript.Echo "USrv012BSubDeletecallsPerSec:" & objItem.USrv012BSubDeletecallsPerSec
	WScript.Echo "USrv013BSubDeletecallLatency:" & objItem.USrv013BSubDeletecallLatency
	WScript.Echo "USrv015NumberofBSubDeletecalls:" & objItem.USrv015NumberofBSubDeletecalls
	WScript.Echo ""
	WScript.Echo "########"
	WScript.Echo ""
Next