✄𐘗
text code block:
✄𐘗from logs-openai_chatgpt_enterprise.app_log-* metadata _id, _version, _index
| where
    data_stream.dataset == "openai_chatgpt_enterprise.app_log" and
    openai_chatgpt_enterprise.app_log.app_name == "Gmail" and
    openai_chatgpt_enterprise.app_log.app_type == "SERVICE" and
    openai_chatgpt_enterprise.app_log.output is not null
| eval Esql.gmail_action = field_extract(openai_chatgpt_enterprise.app_log.output, "response.action_name")
| where Esql.gmail_action == "send_email"
| keep
    _id, _version, _index, @timestamp, user.id, user.email,
    Esql.gmail_action,
    openai_chatgpt_enterprise.app_log.app_name,
    openai_chatgpt_enterprise.app_log.app_type,
    openai_chatgpt_enterprise.app_log.log_type,
    openai_chatgpt_enterprise.app_log.output,
    data_stream.*