Analyzing Network Traffic with VPC Flow Logs Reviews

Akshay S. · Reviewed almost 7 years ago

#standardSQL SELECT jsonPayload.src_vpc.vpc_name, SUM(CAST(jsonPayload.bytes_sent AS INT64)) AS bytes, jsonPayload.src_vpc.subnetwork_name, jsonPayload.connection.src_ip, jsonPayload.connection.src_port, jsonPayload.connection.dest_ip, jsonPayload.connection.dest_port, jsonPayload.connection.protocol FROM `your_table_id` GROUP BY jsonPayload.src_vpc.vpc_name, jsonPayload.src_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

José R. · Reviewed almost 7 years ago

Sameer K. · Reviewed almost 7 years ago

Fabian D. · Reviewed almost 7 years ago

Chris L. · Reviewed almost 7 years ago

ajith t. · Reviewed almost 7 years ago

Itunuoluwa O. · Reviewed almost 7 years ago

Bruno E. · Reviewed almost 7 years ago

Michael L. · Reviewed almost 7 years ago

Arvind G. · Reviewed almost 7 years ago

David R. · Reviewed almost 7 years ago

Do Hun H. · Reviewed almost 7 years ago

Seiji O. · Reviewed almost 7 years ago

Do Hun H. · Reviewed almost 7 years ago

Sittichoke K. · Reviewed almost 7 years ago

Thomas O. · Reviewed almost 7 years ago

Haiyu D. · Reviewed almost 7 years ago

valentin c. · Reviewed almost 7 years ago

Piotr O. · Reviewed almost 7 years ago

wow!

Douglas B. · Reviewed almost 7 years ago

Sean T. · Reviewed almost 7 years ago

Fix the lab for new stackdriver flows and names

Kent M. · Reviewed almost 7 years ago

Aleksandar Z. · Reviewed almost 7 years ago

Jorge A. · Reviewed almost 7 years ago