Where is Alert data stored in the AAI database?

Products

• Automation Analytics & Intelligence

Issue/Introduction

Where is Alert data stored in the AAI database?

Environment

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Resolution

The table the alerts are stored in is named "Alert".

 

The columns in this table are:

 [alertId]

[jobStreamRunId]

[jobSchedulerId]

[severity]

[status]

[creationTime]

[dataValues]

[alertType]

 

Below is a sample query that can return all alerts for a Jobstream, you just need to update the TARGET_JOB for your jobstream and the TIMESTAMP, which needs to be in epoch miliseconds.

 

select js.description, jsr.*, a.*
from JobStream js, JawsJob jj, JobStreamRun jsr, Alert a
where jj.jobName = 'TARGET_JOB'
and jj.jobId = js.targetJobId
and js.jobStreamId = jsr.jobStreamId
and jsr.creationTime > TIMESTAMP
and jsr.jobStreamRunId = a.jobStreamRunId
order by jsr.creationTime, a.creationTime;

 

This website allows you to covert a date into an epoch milliseconds timestamp.

https://www.epochconverter.com/

Please let me know if you have any other questions on this.