Hi Robert,

It does give me the name of the servers but not from that command.

select * from [log_shipping_primary_databases]

select * from [log_shipping_primary_secondaries]

that does give me the names with the same primary id in both the tables.