 Loading |
|
Loading |
| VBScript |
| JavaScript |
| Powershell |
Search Options: WMI Win32_PerfFormattedData_NETDataProviderforSqlServer_NETDataProviderforSqlServer Query
|
||
|
var wbemFlagReturnImmediately = 0x10;
var wbemFlagForwardOnly = 0x20; var arrComputers = new Array("."); for (i = 0; i < arrComputers.length; i++) { WScript.Echo(); WScript.Echo("=========================================="); WScript.Echo("Computer: " + arrComputers[i]); WScript.Echo("=========================================="); var objWMIService = GetObject("winmgmts:\\\\" + arrComputers[i] + "\\root\\CIMV2"); var colItems = objWMIService.ExecQuery("SELECT * FROM Win32_PerfFormattedData_NETDataProviderforSqlServer_NETDataProviderforSqlServer", "WQL", wbemFlagReturnImmediately | wbemFlagForwardOnly); var enumItems = new Enumerator(colItems); for (; !enumItems.atEnd(); enumItems.moveNext()) { var objItem = enumItems.item(); 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); } } | ||
© 2008 - 2013 Boris Toll :: Scripts available: 6.481 :: :: scriptbox.toll.at :: :: powered by www.toll.at :: | ||
