• Not sure if this is quite what you wanted, but you can tweak the query in the article to add in the name of the publication and the name of the subscriber's distribution agent by joining MSpublications and MSdistribution_agents thus:

    select MSpublications.publication,

    MSdistribution_agents.name,

    MSTracer_tokens.publisher_commit,

    MSTracer_tokens.distributor_commit,

    datediff(ss, MSTracer_tokens.publisher_commit, MSTracer_tokens.distributor_commit) 'Latency bw Pub and Dis',

    MStracer_history.subscriber_commit,

    datediff(ss, MSTracer_tokens.distributor_commit, MStracer_history.subscriber_commit) 'Latency bw Dis and Sub'

    from MSpublications

    inner join MSTracer_tokens

    on MSpublications.publication_id = MStracer_tokens.publication_id

    inner join MSTracer_history

    on MSTracer_tokens.tracer_id = MSTracer_history.parent_tracer_id

    inner join MSdistribution_agents

    on MStracer_history.agent_id = MSdistribution_agents.id

    Hope this helps,

    Rachel