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\\Microsoft\\SqlServer\\ComputerManagement10"); var colItems = objWMIService.ExecQuery("SELECT * FROM SqlServiceAdvancedProperty", "WQL", wbemFlagReturnImmediately | wbemFlagForwardOnly); var enumItems = new Enumerator(colItems); for (; !enumItems.atEnd(); enumItems.moveNext()) { var objItem = enumItems.item(); WScript.Echo("IsReadOnly: " + objItem.IsReadOnly); WScript.Echo("PropertyIndex: " + objItem.PropertyIndex); WScript.Echo("PropertyName: " + objItem.PropertyName); WScript.Echo("PropertyNumValue: " + objItem.PropertyNumValue); WScript.Echo("PropertyStrValue: " + objItem.PropertyStrValue); WScript.Echo("PropertyValueType: " + objItem.PropertyValueType); WScript.Echo("ServiceName: " + objItem.ServiceName); WScript.Echo("SqlServiceType: " + objItem.SqlServiceType); } }