Biztalk - SQL Send Ports Monitor

Version 3

    Monitors the status of the Biztalk Send ports via a SQL query

     

    I got sick of hitting double hop security issues with biztalk WMI monitors suggested by Biztalk.

    So instead i checked what the monitor was doing using WMIExplorer, found it was just doing a simple SQL call then replicated that query into a custom SQL Monitor for all our Biztalk Send Ports.

     

    Thought it may be useful to others so here it is.