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?

No Data
Reply Children
No Data