UNIX for Beginners Questions & Answers

duplicate_user_list=`psql cemdb admin -t -f /opt/ca/SAP_Tooling/sql/self_monitoring/duplicate_users.sql|sed '/^$/d' | awk '{print $1}'`
 duplicate_user_count=`psql cemdb admin -t -f /opt/ca/SAP_Tooling/sql/self_monitoring/duplicate_users.sql|sed '/^$/d' | wc -l`

 if [ "$duplicate_user_count" -eq 0 ]
 then
 duplicate_user_status="No Duplicate IP's Found"
 else
 duplicate_user_status="Duplicate IP's Found"

 fi

 if [ "$duplicate_user_count" -gt 0 ]
 then
 echo "mail sent to SAP Tooling Team" | mail -s "$duplicate_user_list" dummyuser@dummydomain.co.uk

$ cat script.sh 
#!/bin/bash
duplicate_user_list="rod jane freddy"
duplicate_user_count=3

if [ "$duplicate_user_count" -gt "0" ]
then
        echo "Duplicate users found, mailing you the details"
        echo "$duplicate_user_list" | mail -s "Details of duplicate users" unixforum@localhost
        exit 1
else
        echo "No duplicate users found"
        exit 0
fi

$ ./script.sh 
Duplicate users found, mailing you the details
$ mail
"/var/mail/unixforum": 1 message 1 new
>N   1 unixforum@localhost Thu Mar  9 13:30  15/667   Details of duplicate users
? 1
<Some headers redacted for privacy reasons>
Subject: Details of duplicate users
To: <unixforum@localhost>
X-Mailer: mail (GNU Mailutils 2.99.99)

rod jane freddy
? d 1
? q
Held 0 messages in /var/mail/unixforum
$

read CNT USR <<< $(psql ... | awk 'NF {T = T " " $1; CNT++} END {print  CNT, T}')

duplicate_user_list=`psql cemdb admin -t -f /opt/ca/SAP_Tooling/sql/self_monitoring/duplicate_users.sql|sed '/^$/d' | awk '{print $1}'`
duplicate_user_count=`psql cemdb admin -t -f /opt/ca/SAP_Tooling/sql/self_monitoring/duplicate_users.sql|sed '/^$/d' | wc -l`

if [ "$duplicate_user_count" -gt 0 ]
then

duplicate_user_status="Duplicate Users Found Emailing The Details"

echo "$duplicate_user_list" | mail -s "Details of Duplicate Users" dummyuser@dummydomain.co.uk

else

duplicate_user_status="No Duplicate Users Found"

fi

echo "<metric type=\"IntCounter\" name=\"SQL|CEMDB|Users:Duplicate User IP Count\" value=\"$duplicate_user_count\"/>"
echo "<metric type=\"StringEvent\" name=\"SQL|CEMDB|Users:Duplicate User IP Status\" value=\"$duplicate_user_status\"/>"

[rp1cem@wycvlapph036 self_monitoring]$ ./epagent_cem_database_metrics_TEST.sh
<metric type="IntCounter" name="SQL|CEMDB|Users:Duplicate User IP Count" value="3"/>
<metric type="StringEvent" name="SQL|CEMDB|Users:Duplicate User IP Status" value="Duplicate Users Found Emailing The Details"/>
[rp1cem@wycvlapph036 self_monitoring]$