AAI report to show all alerts for specific timeframe

Products

• Automation Analytics & Intelligence

Issue/Introduction

Question:

Is there a report that can be used to show how many alerts are created by AAI for a month or so?

Environment

Release : 6.X

Component : Automic Automation Intelligence  

Cause

N/A

Resolution

Answer:

There is no report imbedded in AAI for alerts, the only way to get that information is to query the database. 

The following query can be used:

select * from Alert where creationTime >= 1657220606133 and creationTime < 1658862207067

Dates can be adjust by using https://www.epochconverter.com/ online to utilize needed dates.