I was looking for a linked server in SQL management studio. I can see bunch of linked server but not sure which one I needed.
I found out that following query not only list the linked server name, but also server name, database name information.
Here is the query.
SELECT * from sys.servers
WHERE is_linked = 1