I'm trying to build a monitor to tell me when any database gets added to a SQL server or else gets removed.
This query below will list databases when used with Orion Database Manager or else Visual Studio, however, I'm trying to automate this using APM.
Here's the query
use master
SELECT name FROM sysdatabases
But when I try to use it as an APM component I get this when 'testing' it against a SQL server node:
Testing on node xxxxxxx : failed with 'Down' status
Unable to convert query result.
Does anyone have any suggestions? Thanks!!