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?
Can you check the collection properties and post a screenshot?
From the error message, it looks like it's being stored as an observation, and that "Is Key" was set to true.