SQL Query to XRef BizTalk ReceivePorts to Orchestrations

Suppose you want to know what BizTalk Orchestrations are bound to a send port.
Perhaps you ran my query to list send ports related to a receive port.

NOTE: Still experimental code; haven’t verified much.


select 
 rp.nvcName as 'ReceivePort',
 op.nvcName as 'OrchPort',
 op.nBindingOption, 
 o.nvcName as 'Orchestration'
 --pto.nvcName as 'PortTypeOperation',
 from bts_receiveport rp 
 inner join bts_orchestration_port_binding opb  on rp.nID = opb.nReceivePortID 
 inner join bts_orchestration_port op on op.nID = opb.nOrcPortId --and op.nPortTypeID in (1,9) -- recieve ports only  (9 = activating receive) 
 inner join bts_orchestration o on o.nID = op.nOrchestrationID  
--where rp.nvcName like '%ABC%' 

See also the query on this page to do similar by message type: https://social.msdn.microsoft.com/Forums/en-US/06080af3-7c2f-4460-8b07-a668eab9df12/relate-ports-and-messagetypes?forum=biztalkgeneral.

Uncategorized  

Leave a Reply