sebr-dev

#!/usr/bin/env bash

# Usage: ./crtsh-subdomains-v2.sh domain.com

query="SELECT cai.NAME_VALUE AS NAME_VALUE FROM certificate_and_identities cai WHERE plainto_tsquery('certwatch', '${1}') @@ identities(cai.CERTIFICATE) AND reverse(lower(cai.NAME_VALUE)) LIKE reverse(lower('%.${1}'));"

(echo $1; echo $query | \
    psql -t -h crt.sh -p 5432 -U guest certwatch | \
    sed -e 's:^ *::g' -e 's:^*\.::g' -e '/^$/d' | \
    sed -e 's:*.::g';) | sort -u