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 Randy,

    There is a setting in the Agent Status Properties called "Maximum Rows to Submit for Custom Collection" that should allow you to change the parameter.

    Knowledgebase article 98065 has more information about this configuration setting.

    John
Reply
  • Hi Randy,

    There is a setting in the Agent Status Properties called "Maximum Rows to Submit for Custom Collection" that should allow you to change the parameter.

    Knowledgebase article 98065 has more information about this configuration setting.

    John
Children
No Data