You can define SQL Sentry Advisory Conditions using logical operators.
SQL Sentry Advisory Conditions form an advanced alerting and response system that allows you to truly customize the SQL Sentry to respond to any Windows, virtual machine (VM), or SQL Server database condition with complex logic based on performance counter thresholds, query results, and more.
For example, Advisory Conditions allow you to collect and compare the results of a T-SQL query or WMI query. They also help you automate responses (actions), including sending notifications and executing commands on items specific to your environment and the applications that you support.
The SQL Sentry ship with pre-built Advisory Conditions, which you can configure for your environment. Conditions can be set up at different levels of inheritance within your monitored environment.
You can view the list of Advisory Conditions that are available to you, create a new condition, edit an existing condition, and view the condition events log, which gives you information when the condition was last evaluated for “True,” and more.
Read more independent SQL Sentry reviews on TrustRadius.