return to PRS Technologies website


cnt_rpts_by_user.sh
################################################################################ # # Module: cnt_rpts_by_user.sh # # Description: Count how many reports each user has in Elite-for-Windows # Author: Peter R. Schmidt # # Change Log # # Date Person Description # # 03/28/2002 Peter Schmidt Start program # ################################################################################ dbaccess son_db << EOF unload to "cnt_rpts_by_user.out" select wouser,count(*) from winoutstat group by 1 order by 1 EOF cat cnt_rpts_by_user.out | sort -t "|" +1 -n -r | awk ' \ { printf "%-20s %-6d\n",$1,$2 } ' FS='|' rm cnt_rpts_by_user.out ################################################################################