Powershell MSSQL Monitor.apm-template

Version 2

    This powershell monitor will make a connection to MSSQL, and run a query. The script will then count the number of strings returned, and list these out as the message body. The script will need to be modified to use your query. Look for the $command_text, and update your query. I'm using a 'Select Top 10 From Nodes' for testing against the Orion Database Server. I was having some issues getting arguments passed down to the query, but these are easy enough to hard code into the script if they aren't working for you.

     

    The script needs the server (IP\Instance), the database name, and an updated query for your database.