SQL query | Archive | LogicMonitor Community

Idan · 2017-05-05T21:40:28Z

Hi, Looking for the best option to run a SQL query on one of the databases we have on the SQL server, get the result and: 1. Add value to the server properties so I can see it unxer the info. 2. Create graph from the query results Some of the queries may return one value but some several rows like: Pass 100 Failed 200 Ignored 50 I would like to alert e.g. if we have more than 500 failed. I would like to create chart how many pass, failed, ignore. What is the best option to run those queries ? I would like to get automatically the DB name from the SQL and run it on each database that the database name contain "public"

MoreDiscussions