Shell Programming and Scripting

sh: mimencode: command not found
No message, no subject; hope that's ok

awk 'NR==FNR{a[$1]=$NF;next}
a[$1]{b[$1]=1;print $0 > $1}
END{for(i in a){if(b[i]){system("cat " i " | mail -s OpenOTRStickets "a[i])}}}
' users.txt calls.txt

#!/bin/bash

# VARIABLES

dyfw=/srv/www/htdocs/dyfw               #path to output
user="users.txt"
calls="calls.txt"

# MySQL credentials
u=<username>
p=<password>
d=<database>

# MySQL Query's
qry_usr="SELECT user_id,preferences_value FROM user_preferences WHERE 
preferences_key = 'UserEmail' ORDER BY user_id INTO OUTFILE '$dyfw/$user';"

qry_calls="SELECT user_id,tn,title FROM ticket WHERE ticket_state_id = '1' OR 
ticket_state_id = '4' OR ticket_state_id = '6' ORDER BY tn INTO OUTFILE '$dyfw/$calls';"

# Screen message
echo "MySQL Query running ..."
echo "Output open tickets to /srv/www/htdocs/$calls"
echo "Output users file to /srv/www/htdocs/$user"

# Execute SQL
mysql -u $u -p$p -D $d << eof
$qry_usr
$qry_calls
eof

mail -s "Open calls $nu" support@yourcompany.nl < $dyfw/$calls           #Complete list for the supportdesk

# Generate individual email with a list of open tickets per user
awk 'NR==FNR{a[$1]=$NF;next}
a[$1]{b[$1]=1;print $0 > $1}
END{for(i in a){if(b[i]){system("cat " i " | mail -s OpenOTRStickets "a[i])}}}
' users.txt calls.txt

rm $dyfw/*.txt

awk 'NR==FNR{a[$1]=$NF;next}
a[$1]{b[$1]=1;print $0 > $1 ".txt"}
END{for(i in a){if(b[i]){system("cat " i ".txt | mail -s OpenOTRStickets "a[i])}}}
' users.txt calls.txt