USE BizTalkMgmtDb SELECT app.nvcName AS [Application], ass.nvcName AS [Assembly], orc.nvcName AS [Orchestration], orc.nOrchestrationStatus AS [Status], orp.nvcName AS [Orchestration Port], pt.nvcName AS [Port Type], pto.nvcName AS [Port Type Operation], rp.nvcName AS [Receive Port], rl.Name AS [Receive Location], rppl.Name AS [Receive Pipeline], sp.nvcName AS [Send Port], sppl.Name AS [Send Pipeline], spg.nvcName AS [Send Port Group] FROM bts_application app WITH(NOLOCK) LEFT OUTER JOIN bts_assembly ass WITH(NOLOCK) ON app.nID = ass.nApplicationId LEFT OUTER JOIN bts_orchestration orc WITH(NOLOCK) ON ass.nID = orc.nAssemblyId LEFT OUTER JOIN bts_orchestration_port orp WITH(NOLOCK) ON orc.nID = orp.nOrchestrationId LEFT OUTER JOIN bts_porttype pt WITH(NOLOCK) ON orp.nPortTypeID = pt.nID LEFT OUTER JOIN bts_porttype_operation pto WITH(NOLOCK) ON pt.nID = pto.nPortTypeID LEFT OUTER JOIN bts_orchestration_port_binding opp WITH(NOLOCK) ON orp.nID = opp.nOrcPortID L...