Add the listening TCP port to the Get-SQLServerInfo function output. #29

Add the listening TCP port to the Get-SQLServerInfo function output.

Option #1:
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-connections-transact-sql?view=sql-server-2017

select local_tcp_port from sys.dm_exec_connections where local_net_address is not null

Option #2
xp_regread from the mssql service settings.