|
|
Space moving to next column (awk HTML)
05-23-2018
awk '
BEGIN {
print "From: "
print "To: "
print "MIME-Version: 1.0"
print "Content-Type: text/html"
print "Subject: CPU Used By Aborting session Report"
print "<html><body></br></br>The report provides the list of user who has aborted their queries."
print "<table border=1 cellspacing=1 cellpadding=1>"
}
!/^#/ && /^S/ {
print "<tr>"
for ( i = 1; i <= NF; i++ )
print "<td><b>" $i "<b></td>"
print "</tr>"
}
!/^#/ && !/^S/ {
print "<tr>"
for ( i = 1; i <= NF; i++ )
print "<td>" $i "</td>"
print "</tr>"
}
END {
print "</table></body></html>"
}
' /Reports/output/CPUAbortUser.txt | /usr/sbin/sendmail -tUserName TotalCPU AbortCount AbortType ErrorCode ErrorText MEHROTSQ 12,392.196 3 UserAborted 2,646 No more spool space in mehrotsq. SHAFFERD 3,188.172 2 UserAborted 3,110 The transaction was aborted by the user. ANKIREPA 2.876 2 UserAborted 3,110 The transaction was aborted by the user. CHANDEVI 0.812 3 UserAborted 3,110 The transaction was aborted by the user. DAIJI 0.476 2 UserAborted 3,110 The transaction was aborted by the user. DASMA 0.396 2 UserAborted 3,110 The transaction was aborted by the user.
| Moderator's Comments: | ||
|
05-23-2018
05-23-2018
UserName | TotalCPU| AbortCount|AbortType | ErrorCode|ErrorText MEHROTSQ | 26,582.268| 2|UserAborted| 2,646|No more spool space in mehrotsq. KOCHSR | 13,249.964| 2|UserAborted| 3,110|The transaction was aborted by the user. TUMLISJZ | 9,171.452| 3|UserAborted| 3,110|The transaction was aborted by the user. GILLILPE | 1,333.848| 1|UserAborted| 3,110|The transaction was aborted by the user. HARDIKAR | 0.556| 2|UserAborted| 2,646|No more spool space in hardikar.
| Moderator's Comments: | ||
|
|
|
|
|
