GET SEND PORT DETAILS BY MAP NAME
-----------------------------------------------------------
select
app.nvcName as ApplicationName,
sp.nvcName as SendPortName,
item.FullName as MapName,
map.indoc_docspec_name,
map.outdoc_docspec_name,
sp.nvcFilter
from bts_sendport as sp
inner join bts_sendport_transform as spt on sp.nID = spt.nSendPortID
inner join bts_application as app on app.nID = sp.nApplicationID
left outer join bt_MapSpec as map on map.id = spt.uidTransformGUID
left outer join bts_item as item on item.id = map.itemid
where item.FullName like '%MAP NAME%' -- 1 RECORD WITH THIS CONDITION
-----------------------------------------------------------
GET RECEIVE PORT DETAILS BY URL
-----------------------------------------------------------
select
app.nvcName as ApplicationName,
rp.nvcName,
rl.Name,
rl.InboundTransportURL
from bts_applicatin as app
left join dbo.bts_receiveport as rp on rp.nApplicationID = app.nID
left join dbo.adm_ReceiveLocation as rl on rl.ReceivePortId = rp.nID
left join dbo.bts_receiveport_transform as rpt on rpt.nReceivePortID = rp.nID
where rl.InboundTransportURL like 'URL'
-----------------------------------------------------------
GET SEND PORT DETAILS BY APPLICATION
-----------------------------------------------------------
select
btsApp.nvcName as ApplicationName,
sp.nvcName as SendPortName,
sp.nvcSendPipelineData,
sp.nvcFilter
from bts_application as btsApp
join bts_sendport as sp on btsApp.nID = sp.nApplicationID
where btsApp.nvcName like '%applicatin name%'
