search

m-lab / etl-schema

All schema and views related to the etl pipeline and public bigquery tables.
Apache License 2.0
7 stars 2 forks source link

Exclude additional blacklisted IPs #6

Open stephen-soltesz opened 6 years ago

stephen-soltesz commented 6 years ago 
  AND web100_log_entry.connection_spec.remote_ip != "45.56.98.222"
  AND web100_log_entry.connection_spec.remote_ip != "2600:3c03::f03c:91ff:fe33:819"

35.193.254.117 - script exporter sandbox 35.225.75.192 - script exporter staging 35.192.37.249 - script exporter oti

mattmathis commented 5 years ago

More addresses to add (from sandbox?): 34.66.81.246 35.202.213.74 2600:3c02::0017:d802

(Identification based on traffic pattern, and not confirming actual clients). See: gs://phatbox-data/2019/08/06/08061723-server/all.pcap

mattmathis commented 3 years ago

Do an incremental improvement as part of updating the filters in unified views.

stephen-soltesz commented 3 years ago

@mattmathis who are you addressing?