This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How do you run a custom sql script in a Foglight Rule?

We want to run the following query in a custom rule:

 

SELECT name, is_disabled, is_policy_checked
FROM sys.sql_logins
WHERE is_policy_checked = 0 AND is_disabled = 0
ORDER BY name;  

We want a alarm to fire if the condition is true on any of the instances in Foglight.

 

What is the best way to run a query within a rule?  Is it possible?

Parents
  • Hi,

    In the rule editor, severity level, condition tab, drop down the "Run Condition Query" box and paste in #Login_Count# and execute. It should return a number.

    Then try it with #Login_Count# > 0 and it should return true/false. That will help test the data/logic used in the rule.
Reply
  • Hi,

    In the rule editor, severity level, condition tab, drop down the "Run Condition Query" box and paste in #Login_Count# and execute. It should return a number.

    Then try it with #Login_Count# > 0 and it should return true/false. That will help test the data/logic used in the rule.
Children
No Data