1 of 1 people found this helpful
It sounds like you have already figured out that you need to create a new application monitor template with a SQL user experience component. The requirement for any SQL monitor is the query must output a single row with an integer value in the first column. You may also output a second column that can be a string but this is optional. Again it must be a single row so add "Top 1" to your query, use "count" and "coalesce" strings in your second column.
Once you have your integer you can set thresholds in the component settings to go into a warning or critical status in regards to the value.