#!/bin/sh

/usr/bin/netstat -an|/usr/bin/awk ' BEGIN {
    pmc="KO"; srv="KO"; count_fr=0; count_bd=0; frontales[0]=""; cont_bd[""]=""; hsm_count[""]="";
  }
  /.+193\.16\.243\.254\.2317.+ESTABLISHED/ { pmc="OK"; split ($0,netstat_pmc," ") }
  /.+193\.16\.243\.254\.9128.+ESTABLISHED/ { srv="OK"; split ($0,netstat_srv," ") }
  / .*\.*\.*\.*\.5101.+ESTABLISHED/ { frontales[count_fr]=$0; count_fr++; }
  / .*\.*\.*\.*\.1521.+ESTABLISHED/ { bd[count_bd]=$0; count_bd++; cont_bd[$2]+=1; }
  / .*\.*\.*\.*\.5200.+ESTABLISHED/ { hsm_count[$2]+=1 }

  END {
    print
    print "Conexiones con Redsys:"
    print "PMC:",pmc,"("netstat_pmc[1],"-",netstat_pmc[2],"-", netstat_pmc[7]")"
    print "SRV:",srv,"("netstat_srv[1],"-",netstat_srv[2],"-", netstat_srv[7]")"
    print
    print "Conexiones MAQ con resto de frontales:"
    for (i in frontales)
        print frontales[i]
    print
    print "Conexiones con Base de Datos:"
    for (i in cont_bd)
        if (cont_bd[i] > 0)
          print i,"-",cont_bd[i],"conexiones ESTABLISHED"
    print
    print "Conexiones con HSM:"
    for (i in hsm_count)
        if (hsm_count[i] > 0)
          print i,"-",hsm_count[i],"conexiones ESTABLISHED"
    print
  }'