AWS Lab - How to build AWS VPC Flow Logs for Network Monitoring

Поділитися
Вставка
  • Опубліковано 8 лис 2024

КОМЕНТАРІ • 2

  • @shanumuru
    @shanumuru Рік тому

    it would be helpful if you share the athena query

    • @AWSCloudBytes
      @AWSCloudBytes  Рік тому

      Hey Priya,
      I have updated description to have CloudWatch filter pattern, Athena Table and Athena Query.
      SELECT day_of_week(from_iso8601_timestamp(dt)) AS
      day,
      dt,
      interfaceid,
      sourceaddress,
      destinationport,
      action,
      protocol
      FROM vpc_flow_logs
      WHERE action = 'REJECT' AND protocol = 6
      order by sourceaddress
      LIMIT 100;