Need cleared alarms table name on SOI database

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

Can you please share table name where cleared alarms stored in the Database?

Environment

Release :4.2

Component :CA Service Operations Insight.

Resolution

Alarms are stored in Alerts table.

Alerts table has a column called 'Active' (0 = Inactive or Cleared    1 = Active)
so, when you clear an alert from SOI Console, Active Column values changes
If ypu want to look at only Active alerts (those alerts we see in SOI Alert Console)
Run this query "select * from Alerts where Active = 1"

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/service-operations-insight/4-2/using/alert-management-for-operators/view-alerts-alert-details-and-extended-information_2_3_4.html