SELECT @@SERVERNAME
      ,pid.[publisher_db]
      ,[publication]
	  ,[article]
	  ,[srvname]
	  ,[subscriber_db]
	  ,destination_object
  FROM [distribution].[dbo].[MSpublications] pid 
left join [distribution].[dbo].[MSarticles] msa on pid.publication_id=msa.publication_id 
left join [distribution].[dbo].[MSsubscriptions] mss on pid.publication_id=mss.publication_id 
left join [distribution].[dbo].[MSreplservers] msrepls on mss.subscriber_id=msrepls.srvid
  where mss.subscriber_id>0