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?
They're buried pretty deep in the data model.. I couldn't show it all on one screen, but this will get you down to the collection, and then the metrics (eg. login_count) that you named when you setup the UDC will be draggable to a custom dashboard/report.
They're buried pretty deep in the data model.. I couldn't show it all on one screen, but this will get you down to the collection, and then the metrics (eg. login_count) that you named when you setup the UDC will be draggable to a custom dashboard/report.
