This can be done using the following script
******* START OF SCRIPT ********
strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\Microsoft\SqlServer\ComputerManagement") Set colItems = objWMIService.ExecQuery( _ "SELECT * FROM ServerNetworkProtocolProperty where InstanceName='MSSQLSERVER' and ProtocolName = 'Tcp'",,48) For Each objItem in colItems Wscript.Echo "-----------------------------------" Wscript.Echo "ServerNetworkProtocolProperty instance" Wscript.Echo "-----------------------------------" Wscript.Echo "InstanceName: " & objItem.InstanceName Wscript.Echo "IPAddressName: " & objItem.IPAddressName Wscript.Echo "PropertyName: " & objItem.PropertyName Wscript.Echo "PropertyNumVal: " & objItem.PropertyNumVal Wscript.Echo "PropertyStrVal: " & objItem.PropertyStrVal Wscript.Echo "PropertyType: " & objItem.PropertyType Wscript.Echo "PropertyValType: " & objItem.PropertyValType Wscript.Echo "ProtocolName: " & objItem.ProtocolName Next
******* END OF SCRIPT ********
This uses the class ServerNetworkProtocolProperty. Similarly, you use the above script and modify it to obtain information for the other server network protocols.