Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
tag1
tag1
mail.exchange.messagetracking

Field

Type

Field transformation

Source field name

Extra fields

eventdate

timestamp

host

str

vhost

date_time

timestamp

client_ip

str

client_ip4

ip4

Code Block
ifthenelse(not isnull(client_ip), ip4(client_ip), null)

client_ip

client_hostname

str

server_ip

str

server_ip4

ip4

Code Block
ifthenelse(not isnull(server_ip), ip4(server_ip), null)

server_ip

server_hostname

str

source_context

str

connector_id

str

source

str

event_id

str

internal_message_id

str

message_id

str

network_message_id

str

recipient_address

str

recipient_status

str

total_bytes

int8

recipient_count

int4

related_recipient_address

str

reference

str

message_subject

str

sender_address

str

return_path

str

message_info

str

directionality

str

tenant_id

str

original_client_ip

str

original_client_ip4

ip4

Code Block
ifthenelse(not isnull(original_client_ip), ip4(original_client_ip), null)

original_client_ip

original_server_ip

str

original_server_ip4

ip4

Code Block
ifthenelse(not isnull(original_server_ip), ip4(original_server_ip), null)

original_server_ip

custom_data

str

transport_traffic_type

str

log_id

str

schema_version

str

hostchain

str

tag

str

rawMessage

str

Anchor
tag2
tag2
mail.exchange.ncsa

...