Biztalk SQL Queries: Get List of receive locations and receive ports details by application name

By Application Name:

select
   app.nvcName as ApplicationName,
   rp.nvcName,
   rl.Name,
   rl.InboundTransportURL

from bts_application 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

app.nvcName like 'Application Name'


Biztalk SQL Queries: Get List of receive locations and receive ports details by application name