Forum Discussion

Idan's avatar
8 years ago

SQL query


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"

2 Replies

Replies have been turned off for this discussion