Find out the biztalk applications and it dependants.

SELECT  (select nvcName from [BizTalkMgmtDb].dbo.[bts_application] where nID=appRef.nApplicationID) as MainApplication,
         (select app.nvcName where appRef.nReferencedApplicationID=app.nID) as Dependents
            FROM [BizTalkMgmtDb].[dbo].[bts_application] app
inner join [BizTalkMgmtDb].[dbo].[bts_application_reference] appRef on appRef.[nReferencedApplicationID] = app.nid
where appref.nReferencedApplicationID not in ( '2') order by MainApplication