: !/bin/sh ######################################################################## # T21BATCHNAME tqauto # T21BATCHDESC auto Monthly Extn Group Reports and SW calls and etc. # ALLOWBLANKDATES # CUSTOMDESC # CUSTOMDEF # T21BATCHVAR1DESC # T21BATCHVAR1VALU # T21BATCHVAR2DESC # T21BATCHVAR2VALU # T21BATCHVAR3DESC # T21BATCHVAR3VALU # T21BATCHVAR4DESC # T21BATCHVAR4VALU # T21BATCHVAR5DESC # T21BATCHVAR5VALU # T21BATCHENDARGS ######################################################################## # command line args SDATE=$1; EDATE=$2; STIME=$3; ETIME=$4 ############################## tmpfile="/tmp/tqauto_$$" tmp0file="/tmp/tqauto0_$$" tmp1file="/tmp/tqauto1_$$" tmp2file="/tmp/tqauto2_$$" tmp3file="/tmp/tqauto3_$$" VT_EMAILLIST="robyn.douglas@victrack.com.au michael.bridges@victrack.com.au steve.moodie@victrack.com.au rod@transmit.com.au" #VT_EMAILLIST="tqnew" #VT_EMAILLIST="rod@transmit.com.au" # Testing SDATE="01/10/2015" EDATE="31/10/2015" DODBG="true" ########################################################################### ########################################################################### # send output to file exec >$tmpfile 2>&1 ( echo echo "--------------------------------------------------------------" echo "List of extension groups in groupname that are not in gengroup" runisql 2>&1 < $tmp2file ( echo echo "-------------------------------------------------------------------" echo "List of extension groups in the directory that are not in groupname" runisql 2>&1 <> $tmp2file ######################################################################## ## output group comparison #cat $tmp2file ############################################ # Add left margin cat $tmp2file | \ while read aline do echo " $aline" done >$tmp3file ############################################################################ ## move *specials* extg files #mv $outdir/*n* $extg_mv_dir #mv $outdir/VAC* $extg_mv_dir #mv $outdir/UNAUN* $extg_mv_dir # these have been replaced with individual sql reports # that query the trk_extsum and Directory #... extg_none_fname="extg_none.csv" extg_VAC_fname="extg_VAC.csv" extg_UNAUN_fname="extg_UNAUN.csv" extg_noext_fname="extg_noext.csv" cp /dev/null "$extg_none_fname" cp /dev/null "$extg_VAC_fname" cp /dev/null "$extg_UNAUN_fname" cp /dev/null "$extg_noext_fname" txsql -h -F',' -o "$extg_none_fname" <1 ## email to robyn # Force mail to pass DATE as GMT #TZ=''; export TZ #cat $tmp3file | mail -s "tqauto output" $VT_EMAILLIST # email tqauto results... emaillist="$VT_EMAILLIST" attfiles="$extg_none_fname $extg_VAC_fname $extg_UNAUN_fname $extg_noext_fname" subject="tqauto results" emcontent="TQ auto results" t21em_content=`cat < $HOME/$RPTOPTSTEMP <&1 handlet21rpt echo "here" fi fi # remove temp rptopts file rm -f $HOME/$RPTOPTSTEMP ############################################################ ########################################################################### ########################################################################### ########################################################################### ########################################################################### # generate and email health check reports # set report output options for remaining HEALTH CHECK reports below RPTOPTSTEMP="tmp/.t21rptopts.tmp$runont21_pid" cat > $HOME/$RPTOPTSTEMP <&1 $HUSERDIR/system/batch/callstats "$SDATE" "$EDATE" 00:00 24:00 ALL 1 $DODBG && echo "tqauto: dupdstat" 2>&1 dupdstat "$SDATE" "$EDATE" Nulls S $DODBG && echo "tqauto: swtot" 2>&1 $HUSERDIR/system/batch/swtot "$SDATE" "$EDATE" 00:00 24:00 ALL $DODBG && echo "tqauto: tariffchk" 2>&1 $HUSERDIR/system/batch/tariffchk "$SDATE" "$EDATE" 00:00 24:00 ALL $DODBG && echo "tqauto: swdbadextn.t21batch" 2>&1 $HUSERDIR/system/batch/swdbadextn.t21batch "$SDATE" "$EDATE" 00:00 24:00 ALL $DODBG && echo "tqauto: uextndiv.t21batch" 2>&1 $HUSERDIR/system/batch/uextndiv.t21batch "$SDATE" "$EDATE" 00:00 24:00 ALL $DODBG && echo "tqauto: prtnowarn.t21batch" 2>&1 $HUSERDIR/system/batch/prtnowarn.t21batch "$SDATE" "$EDATE" 00:00 24:00 ALL $DODBG && echo "tqauto: gcat1.t21batch" 2>&1 $HUSERDIR/system/batch/gcat1.t21batch "$SDATE" "$EDATE" 00:00 24:00 ALL "131" ####################################### # set NO PRINT for - fiddis health report # - rejects # - tpcnf T # - tpcnf ALL (comparison) # - long calls cat > $HOME/$RPTOPTSTEMP <&1 $HUSERDIR/system/batch/fiddis.t21batch "$SDATE" "$EDATE" 00:00 24:00 ALL T21BATCHVAR1VALU="T";export T21BATCHVAR1VALU T21BATCHVAR2VALU="ALL";export T21BATCHVAR2VALU T21BATCHVAR3VALU="N";export T21BATCHVAR3VALU T21BATCHVAR4VALU="";export T21BATCHVAR4VALU T21BATCHVAR5VALU="";export T21BATCHVAR5VALU $DODBG && echo "tqauto: tpcnf.t21batch Telstra" 2>&1 $HUSERDIR/system/batch/tpcnf ALL ALL 00:00 24:00 ALL T21BATCHVAR1VALU="ALL";export T21BATCHVAR1VALU T21BATCHVAR2VALU="ALL";export T21BATCHVAR2VALU T21BATCHVAR3VALU="Y";export T21BATCHVAR3VALU T21BATCHVAR4VALU="";export T21BATCHVAR4VALU T21BATCHVAR5VALU="";export T21BATCHVAR5VALU $DODBG && echo "tqauto: tpcnf.t21batch changes" 2>&1 $HUSERDIR/system/batch/tpcnf ALL ALL 00:00 24:00 ALL $DODBG && echo "tqauto: clrrejects.t21batch" 2>&1 $HUSERDIR/system/batch/clrrejects.t21batch "$SDATE" "$EDATE" 00:00 24:00 ALL # dialledno DIAL="ALL"; export DIAL # min duration T21BATCHVAR1VALU="7200"; export T21BATCHVAR1VALU # min callcost T21BATCHVAR2VALU="0.01"; export T21BATCHVAR2VALU $DODBG && echo "tqauto: calls.t21batch" 2>&1 $HUSERDIR/system/batch/calls.t21batch "$SDATE" "$EDATE" 00:00 24:00 ALL "$DIAL" $DODBG && echo "tqauto: uTEC.t21batch" 2>&1 $HUSERDIR/system/batch/uTEC.t21batch "$SDATE" "$EDATE" 00:00 24:00 ALL "" $DODBG && echo "tqauto: xxTEC.t21batch" 2>&1 $HUSERDIR/system/batch/xxTEC.t21batch "$SDATE" "$EDATE" 00:00 24:00 ALL "" #---------------------------------- t21em_subject="tqauto: health/work batch Reports" export t21em_subject ############################################################ ############################################################ ############################################################ ############################################################ ############################################################ # handle concat option # must do it here because rptque will have spoolt21rptopts set # and therefore srct21rptopts will not get RPTOPTSTEMP from above if [ -n "$pr_rep_env_file" -a -f "$pr_rep_env_file" ]; then # handle concat and email all in one options if [ "$t21fileconcat" = "Y" -o \ \( "$t21emailyn" = "Y" -a "$t21emailuuencode" = "3" \) ] then $DODBG && echo "tqauto: handle concat/email-ALL-IN-ONE option(s)" 2>&1 handlet21rpt fi fi # remove temp rptopts file rm -f $HOME/$RPTOPTSTEMP ############################################################ # archive health check reports cd $HOME/health ./doarchealth `date "+tqauto%Y%m%d"` ########################################################################### ## email people that tqauto is complete # #TQNEW_DONE_EMAILLIST='david.cain@victrack.com.au' # ## Force mail to pass DATE as GMT #TZ=''; export TZ #echo "tqauto: Complete." | \ # mail -s "tqauto complete" $TQNEW_DONE_EMAILLIST # ########################## rm -f $tmpfile rm -f $tmp0file rm -f $tmp1file rm -f $tmp2file rm -f $tmp3file # end