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.