This TSQL script will provide means to determine the subscription(s) i.e. filter settings of all the send ports for one- or all BizTalk applications within a BizTalk group. The TSQL script can be run using SQL Management Studio. Information provided by running the script can give a complete overview of all subscriptions in a BizTalk application in case you have a substantual amount of them or you like to view all of them in a BizTalk group.

Note: Feel free to enhance the script to your requirements/demands.

SQL
Edit|Remove
USE BizTalkMgmtDb 
GO 
 
WITH 
TmpXMLNode 
   ( SendPortName 
     , ApplicationName 
     , tmpcol 
   ) 
AS 
   (SELECT 
    SP.nvcName AS SendPortName 
     , APP.nvcName AS ApplicationName 
     , CAST(REPLACE(REPLACE(REPLACE(CONVERT(NVARCHAR(MAX), SP.nvcFilter),'&gt;','>'),'&lt;','<'), 
       'xmlns="http://www.w3.org/2001/XMLSchema-instance"',''AS XMLAS tmpcol 
   FROM 
     bts_sendport AS SP 
     INNER JOIN bts_application AS APP 
       ON SP.nApplicationID = APP.nID 
   WHERE 
    CONVERT(VARCHAR(MAX), nvcFilter) <> '' 
   ) 
 
--All BizTalk applications in a group 
SELECT 
  SendPortName 
   , ApplicationName 
   , CONVERT(VARCHAR(255), nref.query('data(@Property)')) AS FilterProperty 
   , CONVERT(VARCHAR(255), nref.query('data(@Value)')) AS FilterValue 
   , CONVERT(VARCHAR(255), nref.query('data(@Operator)')) As Operator 
FROM 
  TmpXMLNode 
   CROSS APPLY 
     TmpXMLNode.tmpcol.nodes('/Filter/Group/Statement'AS R(nref) 
--One application 
WHERE 
 ApplicationName = '<Your Application Name>'