Description
This alert will track when Active Directory (AD) untrusted domain issues are detected which might prevent Ignite from collecting data when AD authentication is implemented for the Ignite monitor user. When that happens, you will see "untrusted domain" errors in the Ignite logs (CONLOG table). This alert below will proactively alert when those errors are detected in the logs.
Definition
The Ignite Repository must first be registered as a database monitored by Ignite.
To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert with values similar to these:
- Alert Name: Active Directory Issues Detected
- Execution Interval: 10 Min
- Notification Text: Active Directory issues were detected.
- Active Database Instances: Add the Ignite Repository DB only
- Execute Against: Repository
- Units: Issue Count
- High Threshold: Min: 1, Max: Leave Blank
- Broken: Set to same contact as High Threshold.
SQL Statement (SQL Server)
SELECT 'Database Instance Monitor for ' + l.context + ' is not currently running due to Untrusted Domain Errors'
, 1
FROM conlog(NOLOCK) l
INNER JOIN cond(NOLOCK) d
ON d.name = l.context
WHERE l.log_date >= dateadd(minute, - #FREQUENCY#, current_timestamp)
AND lower(message) LIKE '%untrusted%domain%'
SQL Statement (Oracle)
SELECT 'Database Instance Monitor for ' || l.context || ' is not currently running due to Untrusted Domain Errors'
, 1
FROM conlog l
INNER JOIN cond d
ON d.name = l.context
WHERE l.log_date >= current_timestamp - (#FREQUENCY# / 1440)
AND lower(message) LIKE '%untrusted%domain%'
