How to select user IDs from linked servers in SQL Server
The code below can be used to query the linked servers & the user assigned to them.
select s.name, p.principal_id, l.remote_name
from sys.servers s
join sys.linked_logins l
on s.server_id = l.server_id
left join sys.server_principals p
on l.local_principal_id = p.principal_id
where s.is_linked = 1
go