select 
  pub.srvname,      
  sub.srvname,     
  publisher_db,      
  subscriber_db, 
  a.publication,      
  convert(varchar,current_delivery_latency/60000)+' minutes '+ convert(varchar,(current_delivery_latency%60000)/1000)+' seconds'+' ('+convert(varchar,current_delivery_latency/1000)+' seconds)',      
  convert(varchar(1000),comments),     
  convert(varchar,time,21),      
  current_delivery_latency      
  from distributerServerName.distribution.dbo.MSdistribution_agents a 
  join distributerServerName.distribution.dbo.MSdistribution_history h   
  on a.id=h.agent_id  
  join distributerServerName.master.dbo.sysservers pub  
  on a.publisher_id=pub.srvid  
  join distributerServerName.master.dbo.sysservers sub  
  on a.subscriber_id=sub.srvid
  where a.id=h.agent_id       
  and current_delivery_latency>= 4000--latency in seconds      
  and time>dateadd(mi,-10,dateadd(hh,-0,getdate()))
  and comments not like '%No replicated transactions are available%'