SELECT
RL.Name AS ReceiveLocationName
, RL.InboundTransportURL AS InboundTransportURL
, RP.nvcName AS ReceivePortName
, RL.Disabled AS SendPortDisabled
, *
FROM BizTalkMgmtDb.dbo.adm_ReceiveLocation AS RL WITH(READPAST, ROWLOCK)
INNER JOIN BizTalkMgmtDb.dbo.bts_receiveport AS RP WITH(READPAST, ROWLOCK)
ON RL.ReceivePortId = RP.nID
INNER JOIN BizTalkMgmtDb.dbo.bts_application AS APP WITH(READPAST, ROWLOCK)
ON RP.nApplicationID = APP.nID
WHERE
APP.nvcName = 'PROJECT_NAME'
Comments
Post a Comment