Biztalk : Comment Lister les Send Port arrêtés

Bonjour,

Ce petit Post vous donne une maniéré rapide pour attaquer la base de données BizTalkMgmtDb directement pour lister les Send Ports arrêtés .



SELECT
    RL.Name AS ReceiveLocationName
    , RL.InboundTransportURL AS InboundTransportURL
    , RP.nvcName AS ReceivePortName
FROM BizTalkMgmtDb.dbo.adm_ReceiveLocation AS RL WITH(READPAST, ROWLOCK)
    INNER JOIN BizTalkMgmtDb.dbo.bts_receiveport AS RP WITH(READPAST, ROWLOCK)
        ON RL.ReceivePortId = RP.nID
    INNER JOIN BizTalkMgmtDb.dbo.bts_application AS APP WITH(READPAST, ROWLOCK)
        ON RP.nApplicationID = APP.nID
WHERE
    APP.nvcName = '?'
    AND RL.[Disabled] = -1
    AND RL.Name NOT LIKE '%Disabled%'

Download Sql File