• State Not Answered
  • Locked Locked
  • Replies 19 replies
  • Subscribers 59 subscribers
  • Views 13045 views
  • Users 0 members are here
Options
Related
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?

randy.scott
over 6 years ago

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
  • 0 over 6 years ago
    Was in the about the collection not being found in the Administration area when the UDC was being created or somewhere else in the system (e.g. rule management).

    1). In Database Agent log file in the header after parameters and our collection settings, is your UDC collection listed properly under "UserDefined" and registered to Foglight?
    2). There is also a "Custom Collection Detailed" in the Agent's properties page that you can review.
    3). When you do get the error, check the FMS log immediately after to see if there is a message with the timestamp from that moment, or even set the FMS to debug and repeat the error.

    Outside of those steps, I would recommend opening a Service Request and an Engineer could help review the issue with you.

    John
Reply
  • 0 over 6 years ago
    Was in the about the collection not being found in the Administration area when the UDC was being created or somewhere else in the system (e.g. rule management).

    1). In Database Agent log file in the header after parameters and our collection settings, is your UDC collection listed properly under "UserDefined" and registered to Foglight?
    2). There is also a "Custom Collection Detailed" in the Agent's properties page that you can review.
    3). When you do get the error, check the FMS log immediately after to see if there is a message with the timestamp from that moment, or even set the FMS to debug and repeat the error.

    Outside of those steps, I would recommend opening a Service Request and an Engineer could help review the issue with you.

    John
Children
No Data