Skip to content

Instantly share code, notes, and snippets.

@Fitblip

Fitblip/bigquery.sql

Created May 17, 2017 22:18
Show Gist options
  • Save Fitblip/8df573b08c9790c3770cc7899c2c9d30 to your computer and use it in GitHub Desktop.
Save Fitblip/8df573b08c9790c3770cc7899c2c9d30 to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery Punycode Example
Raw
bigquery.sql
SELECT
all_dns_names
FROM
[ctl-lists:certificate_data.scan_data]
WHERE
(REGEXP_MATCH(all_dns_names,r'\b?xn\-\-'))
AND NOT all_dns_names CONTAINS 'cloudflare'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment