# ================= TASK 3: Analyze alerts =================
source ~/lab.env
docker exec $MGR cat /var/ossec/logs/alerts/alerts.json > /tmp/alerts.json
wc -l /tmp/alerts.json

# ---------- 1. affected hosts ----------
jq -r '.agent.name' /tmp/alerts.json | sort | uniq -c | sort -rn

# ---------- 2. frequency ----------
jq -r 'select(.rule.groups|index("authentication_failed") or index("authentication_success")) | [.rule.id,.rule.level,.rule.description]|@tsv' /tmp/alerts.json | sort | uniq -c | sort -rn
jq -r 'select(.rule.groups|index("authentication_failed")) | .timestamp[0:16]' /tmp/alerts.json | sort | uniq -c
jq -r 'select(.rule.groups|index("authentication_failed")) | .data.srcip // "n/a"' /tmp/alerts.json | sort | uniq -c | sort -rn
jq -r 'select(.rule.groups|index("authentication_failed")) | .data.dstuser // "n/a"' /tmp/alerts.json | sort | uniq -c | sort -rn | head

# ---------- 3. severity ----------
jq -r '.rule.level' /tmp/alerts.json | sort -n | uniq -c
jq -r 'select(.rule.level>=10) | [.timestamp[0:19],.agent.name,.rule.level,.rule.id,.data.srcip,.rule.description]|@tsv' /tmp/alerts.json

# ---------- 4. MITRE + success-after-failure ----------
jq -r 'select(.rule.mitre) | .rule.mitre.id[]' /tmp/alerts.json | sort | uniq -c
jq -r 'select(.rule.groups|index("authentication_success")) | [.timestamp[0:19],.data.srcip,.data.dstuser]|@tsv' /tmp/alerts.json

# automatic check: IPs with failures AND a success
comm -12 \
 <(jq -r 'select(.rule.groups|index("authentication_failed")) | .data.srcip // empty' /tmp/alerts.json | sort -u) \
 <(jq -r 'select(.rule.groups|index("authentication_success")) | .data.srcip // empty' /tmp/alerts.json | sort -u)
# any IP printed = possible compromised account

# ---------- 5. dashboard DQL queries ----------
echo "rule.groups: authentication_failed and data.srcip: \"$ATTACKER_BRUTE\""
echo "rule.groups: authentication_success and data.srcip: \"$ATTACKER_BRUTE\""
echo "rule.level >= 10"
# paste the printed queries into Threat Hunting -> Events
# columns: timestamp, agent.name, rule.id, rule.level, rule.description, data.srcip, data.dstuser

# ---------- 6. worksheet ----------
# Affected host   : $AGENT_NAME (agent 001)
# Time window     : <first alert> to <last alert>
# Frequency       : <N> failures, peak <N>/min at <time>
# Top sources     : $ATTACKER_BRUTE (<N>), $ATTACKER_ENUM (<N>), $BENIGN_IP (<N>, benign)
# Targeted users  : root, $LAB_USER, admin, oracle ...
# Severity        : failures level 5; brute-force rule level 10+; success level 3 (critical in context)
# Possible causes : 1 automated brute force  2 user enumeration  3 compromised credential
#                   4 benign typo  5 misconfigured service retrying old password
# Conclusion      : brute-force pattern (MITRE T1110) with possible account compromise