Query: List distinct interface IDs found in all flow logs that occurred over the last hour

Description

Identify unique interface IDs present in all flow logs from the past hour. This can be useful for monitoring activity and identifying unusual or suspicious network events in real-time.

Query

Tables used in this query:

• aws_vpc_flow_log_event

SQL