while ( my $line = <DATA> ) {
  next if $line =~ /Insufficent|CLEARED/;
  if ( $line =~ /SNMP/ ) {
    my @f = split /\|/, $line; 
    my $node_ip = $f[4] || 'N/A';
    my $message = $f[13];
    my (undef,$ne) = split /[ &]+/,$f[15];
    
     if ( $seen{$ne} ){
       ++$seen{$ne}[0];
     } else {
       $seen{$ne} = [ 1, $node_ip, $ne, $message ];
    }
  }
}

for my $ne ( sort keys %seen ){
  printf "%d | %-15s | %9s | %s \n", @{$seen{$ne}};
}