Contact Info

Crumbtrail

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

Win32_PerfFormattedData_NETDataProviderforSqlServer vbscript 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_NETDataProviderforSqlServer WMI class can be used in ActiveXperts Network Monitor to monitor your servers.


Sample Code

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

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

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 "HardConnectsPerSecond:" & objItem.HardConnectsPerSecond
	WScript.Echo "HardDisconnectsPerSecond:" & objItem.HardDisconnectsPerSecond
	WScript.Echo "Name:" & objItem.Name
	WScript.Echo "NumberOfActiveConnectionPoolGroups:" & objItem.NumberOfActiveConnectionPoolGroups
	WScript.Echo "NumberOfActiveConnectionPools:" & objItem.NumberOfActiveConnectionPools
	WScript.Echo "NumberOfActiveConnections:" & objItem.NumberOfActiveConnections
	WScript.Echo "NumberOfFreeConnections:" & objItem.NumberOfFreeConnections
	WScript.Echo "NumberOfInactiveConnectionPoolGroups:" & objItem.NumberOfInactiveConnectionPoolGroups
	WScript.Echo "NumberOfInactiveConnectionPools:" & objItem.NumberOfInactiveConnectionPools
	WScript.Echo "NumberOfNonPooledConnections:" & objItem.NumberOfNonPooledConnections
	WScript.Echo "NumberOfPooledConnections:" & objItem.NumberOfPooledConnections
	WScript.Echo "NumberOfReclaimedConnections:" & objItem.NumberOfReclaimedConnections
	WScript.Echo "NumberOfStasisConnections:" & objItem.NumberOfStasisConnections
	WScript.Echo "SoftConnectsPerSecond:" & objItem.SoftConnectsPerSecond
	WScript.Echo "SoftDisconnectsPerSecond:" & objItem.SoftDisconnectsPerSecond
	WScript.Echo "Timestamp_Object:" & objItem.Timestamp_Object
	WScript.Echo "Timestamp_PerfTime:" & objItem.Timestamp_PerfTime
	WScript.Echo "Timestamp_Sys100NS:" & objItem.Timestamp_Sys100NS
	WScript.Echo ""
	WScript.Echo "########"
	WScript.Echo ""
Next