Analyzing Network Traffic with VPC Flow Logs Reviews

Lakshmi Anjaneya Gayathri Praneeth M. · Reviewed over 1 year ago

Muhammad A. · Reviewed over 1 year ago

Masoom R. · Reviewed over 1 year ago

Aryan R. · Reviewed over 1 year ago

Luan P. · Reviewed over 1 year ago

hans t. · Reviewed over 1 year ago

good

Ahab A. · Reviewed over 1 year ago

PIYUSH M. · Reviewed over 1 year ago

Avijit B. · Reviewed over 1 year ago

Nilankan P. · Reviewed over 1 year ago

Anik D. · Reviewed over 1 year ago

Maretza . · Reviewed over 1 year ago

gcparcade G. · Reviewed over 1 year ago

Sanjit D. · Reviewed over 1 year ago

BAHRUL H. · Reviewed over 1 year ago

good lab

Ruddraksh P. · Reviewed over 1 year ago

Aliya Zalfa Putri C. · Reviewed over 1 year ago

Ayako M. · Reviewed over 1 year ago

Md Faraz Ali A. · Reviewed over 1 year ago

mk

Trilochan G. · Reviewed over 1 year ago

Muhammad Hanan Rafi Hadi Prayogo C. · Reviewed over 1 year ago

Bhavishya A. · Reviewed over 1 year ago

Humaidi A. · Reviewed over 1 year ago

José Luis O. · Reviewed over 1 year ago

I had to change src to dest to make the first query work: #standardSQL SELECT jsonPayload.dest_vpc.vpc_name, SUM(CAST(jsonPayload.bytes_sent AS INT64)) AS bytes, jsonPayload.dest_vpc.subnetwork_name, jsonPayload.connection.src_ip, jsonPayload.connection.src_port, jsonPayload.connection.dest_ip, jsonPayload.connection.dest_port, jsonPayload.connection.protocol FROM `qwiklabs-gcp-00-8dee8b82c3e8.bq_vpcflows.compute_googleapis_com_vpc_flows_20241011` GROUP BY jsonPayload.dest_vpc.vpc_name, jsonPayload.dest_vpc.subnetwork_name, jsonPayload.connection.src_ip, jsonPayload.connection.src_port, jsonPayload.connection.dest_ip, jsonPayload.connection.dest_port, jsonPayload.connection.protocol ORDER BY bytes DESC LIMIT 15

Alma Fabiola S. · Reviewed over 1 year ago