I was asked today to help on a long running hierarchy replication task. I pointed my customer to the default report whilst I was searching a hand crafted SQL to do the same, with a slightly friendlier look to it.
I found it, so I sent it to them and I share it with the Community now:
rs._eventTime as 'Event time',
replace (src.name, '.15-cloud.fr', '') + ' --> ' +
replace (dst.name, '.15-cloud.fr', '') +
case src.name when 'vbox-atrs5.15-cloud.fr' then ' (Down)' else ' (Up)' end as 'Details',
cast(rs.TotalReplicationCount as varchar) as 'Objects (total)',
cast (rs.FailedReplicationCount as varchar) as 'Failed',
cast (rs.DataTransferred as varchar) as 'Size in KiB',
cast (DATEDIFF(mi, rs.[StartTime], rs.[FinishTime] ) as varchar)AS 'Duration (mins)'