List service queues, services, message types and contracts

service_broker.sql

select sc.name as service_contract_name, smt.name as service_message_type_name, s.name as service_name, sq.name
from sys.service_contracts sc
         join sys.service_contract_message_usages scmu on sc.service_contract_id = scmu.service_contract_id
         join sys.service_message_types smt on scmu.message_type_id = smt.message_type_id
         join sys.service_contract_usages scu on sc.service_contract_id = scu.service_contract_id
         join sys.services s on scu.service_id = s.service_id
         join sys.service_queue_usages squ on squ.service_id = s.service_id
         join sys.service_queues sq on squ.service_queue_id = sq.object_id