Transactional Replication Information (Publisher–Publication-Articles-Subscriber–Articles)

Written a script to pull list of each table in a subscription and when the last time the table replicated.

use [distribution] select sss.srvname PublisherServer,mss.publication_id,mss.publisher_db, msa.article Publisher_Articals, sss1.srvname SubscriberServer,mss.subscriber_id,mss.subscriber_db,mss.article_id, msa.destination_object Subscriber_Articals, mss.subscription_time from MSsubscriptions mss join sys.sysservers sss on mss.publisher_id=sss.srvid join sys.sysservers sss1 on mss.subscriber_id=sss1.srvid join MSarticles msa on mss.publisher_id=msa.publisher_id and mss.article_id=msa.article_id