Get List of Linked Servers and associated logins

Script to get Linked server list. We have repeated linked server name if it has more than one associated remote login.

SELECT @@SERVERNAME AS 'Server Name'
,      sys.servers.server_id AS 'IdLinkedServer'
,      sys.servers.name AS 'Linked Server Name'
,      CASE sys.servers.Server_id WHEN 0 THEN 'Current Server'
                                         ELSE 'Remote Server' END AS 'Server '
,      sys.servers.product
,      sys.servers.provider
,      sys.servers.data_source
,      sys.servers.catalog
,      CASE sys.linked_logins.uses_self_credential WHEN 1 THEN 'Uses Self Credentials'
                                                          ELSE sys.server_principals.name END AS 'Local Login '
,      sys.linked_logins.remote_name AS 'Remote Login Name'
,      CASE sys.servers.is_rpc_out_enabled WHEN 1 THEN 'True'
                                                  ELSE 'False' END AS 'RPC Out Enabled'
,      CASE sys.servers.is_data_access_enabled WHEN 1 THEN 'True'
                                                      ELSE 'False' END AS 'Data Access Enabled'
,      sys.servers.modify_date
FROM            sys.servers          
LEFT OUTER JOIN sys.linked_logins     ON sys.servers.server_id = sys.linked_logins.server_id
LEFT OUTER JOIN sys.server_principals ON sys.server_principals.principal_id = sys.linked_logins.local_principal_id

Source: https://gallery.technet.microsoft.com/scriptcenter/Get-List-of-Linked-Server-d6c95d9c