Hi Guys, Does anyone know how i would retrieve the instance name of every SQL server instance and then for each instance pull back the edition? I have some WMI code which can pull back the instance name but then for each instance it pulls back every edition for each instance. Any ideas? On Error Resume Next Const wbemFlagReturnImmediately = &h10 Const wbemFlagForwardOnly = &h20 arrComputers = Array("localhost") For Each strComputer In arrComputers WScript.Echo WScript.Echo "==========================================" WScript.Echo "Computer: " & strComputer WScript.Echo "==========================================" Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\Microsoft\SqlServer\ComputerManagement") Set colItems = objWMIService.ExecQuery("SELECT * FROM ServerSettings", "WQL", _ wbemFlagReturnImmediately + wbemFlagForwardOnly) For Each objItem In colItems WScript.Echo "InstanceName: " & objItem.InstanceName WScript.Echo Set objWMIService2 = GetObject("winmgmts:\\" & strComputer & "\root\Microsoft\SqlServer\ComputerManagement") Set colItems2 = objWMIService2.ExecQuery("SELECT * FROM SqlServiceAdvancedProperty WHERE PropertyName = 'SKUNAME'", "WQL", _ wbemFlagReturnImmediately + wbemFlagForwardOnly) For Each objItem2 In colItems2 WScript.Echo "IsReadOnly: " & objItem2.IsReadOnly WScript.Echo "PropertyIndex: " & objItem2.PropertyIndex WScript.Echo "PropertyName: " & objItem2.PropertyName WScript.Echo "PropertyNumValue: " & objItem2.PropertyNumValue WScript.Echo "PropertyStrValue: " & objItem2.PropertyStrValue WScript.Echo "PropertyValueType: " & objItem2.PropertyValueType WScript.Echo "ServiceName: " & objItem2.ServiceName WScript.Echo "SqlServiceType: " & objItem2.SqlServiceType WScript.Echo Next Next Next
