conversation_endpoints$

This is a view in the mssqlsystemresource database.

CREATE VIEW sys.conversation_endpoints$ AS  SELECT conversation_handle = s.handle,   conversation_id = s.diagid,   is_initiator = sysconv(bit, s.initiator),   service_contract_id = r.contract,   conversation_group_id = r.convgroup,   service_id = r.svcid,   lifetime = r.lifetime,   state = r.state,   state_desc = i.name,   far_service = r.farsvc,   far_broker_instance = r.farbrkrinst,   principal_id = r.princid,   far_principal_id = r.farprincid,   outbound_session_key_identifier = r.outseskeyid,   inbound_session_key_identifier = r.inseskeyid,   security_timestamp = r.dlgopened,   dialog_timer = r.dlgtimer,   send_sequence = s.sendseq,   last_send_tran_id = s.sendxact,   end_dialog_sequence = r.enddlgseq,   receive_sequence = r.rcvseq,   receive_sequence_frag = r.rcvfrag,   system_sequence = r.sysseq,   first_out_of_order_sequence = r.firstoorder,   last_out_of_order_sequence = r.lastoorder,   last_out_of_order_frag = r.lastoorderfr,   is_system = sysconv(bit, r.status & 1),   priority = r.priority  FROM sys.sysdesend s  JOIN sys.sysdercv r ON r.handle = s.handle AND r.diagid = s.diagid AND r.initiator = s.initiator  LEFT JOIN sys.syspalnames i ON i.class = 'CEST' AND i.value = r.state