cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Custom Alert - Active Directory Untrusted Domain Issues Detected

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.

ALERT 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

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)

and lower(message) like '%untrusted%domain%'

Execute Against: Repository

Units: Issue Count

High Threshold: Min: 1, Max: Leave Blank

Broken: Set to same contact as High Threshold.

Version history
Revision #:
1 of 1
Last update:
‎02-13-2014 05:49 PM
Updated by: