select 	
  sq.name queue_name, 
  ce.conversation_handle,
  case 
    when ce.is_initiator = 1 and (db.name is null) then '-->' -- far
    when ce.is_initiator = 1 and (db.name is not null) then '->' -- local
    when ce.is_initiator = 0 and (db.name is not null) then '<-' -- local
    when ce.is_initiator = 0 and (db.name is null) then '<--' -- far
    else 'n/a'
  end direction_sign,
  cast(choose(isnull(ce.is_initiator+1, 3), 'in', 'out', 'n/a') as nvarchar(3)) direction_txt,
  iif(
    ce.is_initiator = 1, 
    '(local) ', 
    iif(
      db.name is null, 
      '(remote ' + isnull(rt.name, '[no info]') COLLATE Cyrillic_General_CI_AS + ') ', 
      -- если вдруг rt.name is null то с диалогом что-то не то, вероятнее всего создали когда-то и бросили, а route удалили
      '(local) '
    )
  ) + se.name [from_service_or_route], 
  iif(
    ce.is_initiator = 0, 
    '(local) ', 
    iif(
      db.name is null, 
      '(remote '  + isnull(rt.name, '[no info]') COLLATE Cyrillic_General_CI_AS + ') ', 
      '(local) '
    ) 
  ) + ce.far_service [to_service_or_route],
  ce.state ce_state,  get_transmission_status(ce.conversation_handle) transmission_status,
  ce.send_sequence, ce.receive_sequence, ce.receive_sequence_frag,
  qm.last_activated_time -- время в UTC+0
  --qm.state, qm.tasks_waiting
from 
  sys.service_queues sq 
  inner join sys.service_queue_usages qu on qu.service_queue_id = sq.object_id
  inner join sys.services se on se.service_id = qu.service_id
  left join sys.dm_broker_queue_monitors qm on qm.queue_id = qu.service_queue_id
  left join sys.conversation_endpoints ce on ce.service_id = se.service_id 
  left join sys.routes rt on rt.broker_instance = ce.far_broker_instance and rt.remote_service_name = ce.far_service
  left join sys.databases db on db.service_broker_guid = ce.far_broker_instance