anl_dim_tiers

Stores a distinct set of tiers of escalation for each event. These tiers are used in the client's alert escalation strategy.

Table 1. anl_dim_tiers table
Column Description Example
event_id

bigint

The event id.

4457548
tier_id

bigint

The unique tier id.

3
tier_name

varchar

The name of this tier in the escalation.

PRIMARY
tier_started

datetime

The start date for when the tier applies for the given event.

2017-11-14 08:54:23.270000
tier_ended

datetime

The end date for when the tier applies for the given event.

2199-12-31 00:00:00.000000
created_at

datetime

The creation date.

2017-12-06 04:39:36.358000
updated_at

datetime

The last updated date.

2017-12-06 04:39:36.358000
source_id

bigint

The source id of the appliance providing data.

1
control_id

bigint

The control id, indicating when the record was loaded or updated.

12639