Biztalk : Comment Lister les Receive Locations 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 Receive Locations arrêtés .

SELECT

    SPTP.nvcAddress AS SendingURI

    , SP.nvcName AS SendPortName

FROM

    BizTalkMgmtDb.dbo.bts_sendport_transport AS SPTP WITH(READPAST, ROWLOCK)

    INNER JOIN BizTalkMgmtDb.dbo.bts_sendport AS SP WITH(READPAST, ROWLOCK)

        ON SPTP.nSendPortID = SP.nID

    INNER JOIN BizTalkMgmtDb.dbo.bts_application AS APP WITH(READPAST, ROWLOCK)

        ON SP.nApplicationID = APP.nID

WHERE

    APP.nvcName = '?'

    AND SP.nPortStatus <> 3

    AND SP.nvcName NOT LIKE '%unenlisted%'

    AND SPTP.nTransportTypeId IS NOT NULL

Download Sql File