How to find servername, instance name and running port

Find_server_and_instance_name_with_port.sql

SELECT 
	 @@SERVERNAME AS srvname, @@SERVICENAME AS service -- these two are inaccurate 
	,SERVERPROPERTY('ServerName') AS ServerName -- this includes the instancename, if there
	,SERVERPROPERTY('InstanceName') AS InstanceName 
	,SERVERPROPERTY('Edition') AS Edition 
	,SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS NetBIOS 
	 -- local_tcp_port: Requires VIEW SERVER STATE permission on object 'server' 
	,(
		SELECT TOP 1 
			local_tcp_port 
		FROM sys.dm_exec_connections 
		WHERE local_tcp_port IS NOT NULL 
		ORDER BY last_write DESC 
	) AS port 

-- ===========================

-- Registry: 
SET NOCOUNT ON; 

DECLARE @key varchar(100), @PortNumber varchar(20)

IF CHARINDEX('\', CONVERT(char(20), SERVERPROPERTY('servername')), 0) <> 0
BEGIN 
    SET @key = 'SOFTWARE\MICROSOFT\Microsoft SQL Server\' + @@servicename + '\MSSQLServer\Supersocketnetlib\TCP'; 
END 
ELSE 
BEGIN 
    SET @key = 'SOFTWARE\MICROSOFT\MSSQLServer\MSSQLServer\Supersocketnetlib\TCP'; 
END 

EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE', @key=@key, @value_name='Tcpport', @value=@PortNumber OUTPUT

SELECT 
     CONVERT(char(20), SERVERPROPERTY('servername')) AS ServerName 
    ,CONVERT(char(20), SERVERPROPERTY('InstanceName')) AS InstanceName 
    ,CONVERT(char(20), SERVERPROPERTY('MachineName')) AS HostName 
    ,CONVERT(varchar(10),@PortNumber) AS PortNumber 

-- ===================================


DECLARE @props TABLE (propertyname sysname PRIMARY KEY)
INSERT INTO @props(propertyname)
SELECT 'BuildClrVersion'
UNION
SELECT 'Collation'
UNION
SELECT 'CollationID'
UNION
SELECT 'ComparisonStyle'
UNION
SELECT 'ComputerNamePhysicalNetBIOS'
UNION
SELECT 'Edition'
UNION
SELECT 'EditionID'
UNION
SELECT 'EngineEdition'
UNION
SELECT 'InstanceName'
UNION
SELECT 'IsClustered'
UNION
SELECT 'IsFullTextInstalled'
UNION
SELECT 'IsIntegratedSecurityOnly'
UNION
SELECT 'IsSingleUser'
UNION
SELECT 'LCID'
UNION
SELECT 'LicenseType'
UNION
SELECT 'MachineName'
UNION
SELECT 'NumLicenses'
UNION
SELECT 'ProcessID'
UNION
SELECT 'ProductVersion'
UNION
SELECT 'ProductLevel'
UNION
SELECT 'ResourceLastUpdateDateTime'
UNION
SELECT 'ResourceVersion'
UNION
SELECT 'ServerName'
UNION
SELECT 'SqlCharSet'
UNION
SELECT 'SqlCharSetName'
UNION
SELECT 'SqlSortOrder'
UNION
SELECT 'SqlSortOrderName'
UNION
SELECT 'FilestreamShareName'
UNION
SELECT 'FilestreamConfiguredLevel'
UNION
SELECT 'FilestreamEffectiveLevel'
 
SELECT propertyname, SERVERPROPERTY(propertyname) FROM @props