Multi-Value PowerShell SQLCMD Wrapper

Version 1

    This is a simple PowerShell multi-value wrapper for SQLCMD queries against a Microsoft SQL database. In this example, we are quering two different tables of a database to get custom BizTalk Orchestration States for a Microsoft BizTalk ecosystem.

     

     

    To Configure this monitor:

     

     

    1) Run winrm quickconfig on the target database server

    2) Run the monitor as 'Agentless' and 'x86'

    3) Populate the multi-value output by running 'Edit Script' and setting the target server and credentials to use. After the values populate, you can tweak the alert thresholds (if desired).

     

     

    Note: SolarWinds script monitors are limited to a maximum 10 pairs of statistics and messages.

     

     

    Written by Kristina Sterling Engan.