SQL Query to list BizTalk Hosts

This query will give you a list of the BizTalk Hosts:

--Hosts
SELECT  nvcApplicationName,
        uidAppID,
        fAttributes
FROM [BizTalkMsgBoxDb].[dbo].[Applications](NOLOCK)