Custom Alert - Active Directory Untrusted Domain Issues Detected
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.
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
SQL Statement (Pick the proper statement below depending on if your Repository is on SQL Server or Oracle)
SQL Server Repository Statement:
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%'
Oracle Repository Statement:
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)
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.