#!/bin/bash
cd /root/recon
for p in panos sonicwall screenconnect beyondtrust cisco vmware checkpoint gitlab fortinet; do
  awk -F'\t' -v p="$p" 'index($5,p)>0 {print $1"\t"$2"\t"$4}' hitsB.tsv | sort -u > prod_$p.tsv
  echo "$p: $(wc -l < prod_$p.tsv)"
done
echo '--- dom_ip format:'; head -2 dom_ip.tsv
echo '--- panos titles:'; cut -f2,3 prod_panos.tsv | sort | uniq -c | sort -rn | head -8
echo '--- sonicwall titles:'; cut -f2,3 prod_sonicwall.tsv | sort | uniq -c | sort -rn | head -8
echo '--- screenconnect:'; cut -c1-120 prod_screenconnect.tsv | head -20
echo '--- beyondtrust:'; cut -f2,3 prod_beyondtrust.tsv | sort | uniq -c | sort -rn | head -8
