Schema for Opsgenie

acknowledge_time

Number

144849655

Time (in milliseconds) it took to acknowledge the alert

acknowledged_by

String

Links to a record in the opsgenie_user table.

This can also contain only a string value that does not relate to opsgenier_user.

actions

Array

["Restart", "Ping"]

User-defined actions for the alert

alias

String

Alias used for the alert

close_time

Numer

144849655

Time (in milliseconds) it took to close the alert

closed_by

String

Links to a record in the opsgenie_user table.

This can also contain only a string value that does not relate to opsgenier_user.

created_at

Datetime

Alert creation time (UTC time zone)

customer_id

String

Unique Opsgenie customer identifier

deduplication_count

Number

3

Number of times the alert occured

description

String

Example description

Description of the alert

entity

String

EC2

User-defined entity to which the alert belongs

id

String

<Alert ARI>

Unique alert identifier. Use it as the primary key for alert data.

integration_id

String

The integration used to raise this alert. Links to a record in the opsgenie_integration table.

is_acknowledged

Boolean

true

true if alert was acknowledge; otherwise, false

is_seen

Boolean

true

true if the alert is seen; otherwise, false

is_snoozed

Boolean

false

true if the alert is snoozed; otherwise, false

last_occured_at

Datetime

The last time that the alert occured

message

String

[EU] ALARM: "SQS Queue devops_adapter_deployment_calc_lock_customer_queue-dlq messa..." in EU (Frankfurt)

Message of the alert

owner

String

Owner of the alert

Identifier of the user

Links to a record in the opsgenie_user table.

This can also contain only a string value that does not relate to opsgenier_user.

priority

String

P3

Priority of the alert

snoozed_until_at

Datetime

Time when the alert is no longer snoozed

source

String

CloudWatch

Source of the alert

status

String

closed

Status of the alert

tags

Array

["closeLocked", "eu"]

Tags associated with the alert

tiny_id

String

1036

Tiny ID associated with an alert. It will repeat after 99,999.

updated_at

Datetime

Last time the alert was updated (UTC time zone)

workspace_id

String

The unique identifier of the workspace

alert_id

String

Unique alert identifier. Use it with the alert’s key as the primary key for alert details data.

customer_id

String

Unique Opsgenie customer identifier

key

String

MonitorNodeId

Alert detail key. Use it with the alert_id as the primary key for alert details data.

value

String

DevOpsMonitoring

Alert detail value

workspace_id

String

The unique identifier of the workspace

alert_id

String

Unique alert identifier. Use it with responder_id and type as the primary key for alert responder data.

customer_id

String

Unique Opsgenie customer identifier

inserted_at / inserted_date

Datetime / Date

Time when the record was inserted

responder_id

String

Unique identifier of the responder. Use it with type and alert_id as the primary key for alert responder data.

Together with customerId and type it links to the record in opsgenie_user/opsgenie_team/opsgenie_schedule/opsgenie_escalationtable.

type

String

user / team / escalation / schedule

Type of responder. Use it with alert_id and responder_id as the primary key for alert responder data.

workspace_id

String

The unique identifier of the workspace

alert_id

String

Unique alert identifier

customer_id

String

Unique Opsgenie customer identifier

inserted_at / inserted_date

Datetime / Date

Time when the record was inserted

is_aware

Boolean

true

true if alert recipient is aware of the alert; otherwise, false

is_oncall

Boolean

true

true if alert recipient is oncall; otherwise, false

is_seen

Boolean

true

true if alert recipient has seen the alert; otherwise, false

method

String

email

Method used to inform the alert recipient

state

String

sent

State of user reception

user_id

String

Unique user recipient identifier. Use it with customer_id as the primary key for alert user recipient data.

alert_id

String

Unique identifier of the alert. Links to a record in the opsgenie_alert table.

created_at

Datetime

2021-07-29 06:41:40.707000000

Time when the issue was created (UTC time zone)

customer_id

String

Unique Opsgenie customer identifier

delivery_method

String

VOICE / SMS / MOBILE / EMAIL

Method used for the notification

destination

String

nissan@weely.com/1-6666666666

Destination address of the notification

id

String

Unique notification identifier. Use it as the primary key for notification data.

is_mass_notification

Boolean

true

true when it is a mass notification; otherwise, false

notified_user_id

String

Unique user identifier. Links to a record in the opsgenier_user table.

reason

String

Create/Weekly Report/notificationAggregation/scheduleEnd/scheduleStart/Close/AddNote/Acknowledge/AddResponder/rigthToBeForgotten/simpleGenericSms/userRevokeFailed/customerDataDeletion/AssignOwnership

Reason for the notification

received_at

Datetime

2021-07-29 23:50:39.984000000

Time when the notification was received (UTC time zone)

sent_at

Datetime

2021-07-29 06:41:40.707000000

Time when the notification was sent (UTC time zone)

source

String

ALERT / SCHEDULE / AGGREGATED / SYSTEM / reporting

Domain of notification for which it was triggered

status

String

SENT / RECEIVED / FAILED

Status of the notification

user_type

String

Owner / Admin / User / Stakeholder

The type of user that is assigned to a particular account

workspace_id

String

The unique identifier of the workspace