Tables installed with Service Analytics

Service Analytics adds the following tables.

Table Description
SA RCA Status

[sa_rca_status]

Information (such as IDs) for the latest messages that were sent to the ECC Queue for a service during RCA.
SA RCA Output

[sa_rca_output ]

RCA learner output data.
SA RCA Group

[sa_rca_group]

Correlated alert groups for the RCA query.
SA Analytics Alert Staging

[sa_analytics_alert ]

Staging table for alerts used for analytics.
SA Alert Aggregation Query

[sa_agg_query]

Alert aggregation query results.
SA RCA Input

[sa_rca_input]

Input data for the RCA learner.
SA Analytics Status

[sa_analytics_status]

Last run information to be used for alert aggregation and RCA.
SA RCA Group Alert

[sa_rca_group_alert ]

Alerts associated with correlated alert groups.
SA RCA Service Configuration Item Association

[sa_rca_svc_ci_assoc]

Associations between CIs and services.