SQL Server TCP Port Number

Today I came accross an interesting TSQL in the blog spicifed below to find out the TCP Port number SQL Server instance was listening on,

 

http://www.sqlservercentral.com/blogs/adventuresinsql/2010/11/29/using-dmvs-to-find-the-ports-that-sql-server-is-listening-on/

 

SELECT      e.name,             e.endpoint_id,             e.principal_id,             e.protocol,             e.protocol_desc,             ec.local_net_address,             ec.local_tcp_port,             e.[type],             e.type_desc,             e.[state],             e.state_desc,             e.is_admin_endpoint FROM        sys.endpoints e             LEFT OUTER JOIN sys.dm_exec_connections ec                 ON ec.endpoint_id = e.endpoint_id GROUP BY    e.name,             e.endpoint_id,             e.principal_id,             e.protocol,             e.protocol_desc,             ec.local_net_address,             ec.local_tcp_port,             e.[type],             e.type_desc,             e.[state],             e.state_desc,             e.is_admin_endpoint

The Script works perfectly fine, I tried using DISTINCT instead of Group by that works fine too. Thanks to the blogger for the script.