bdae98b8683d0e559cb5765c52a95e2af42cffa8 dschmelt Mon Oct 24 14:28:51 2022 -0700 Checking in script No RM diff --git src/utils/qa/userCount src/utils/qa/userCount new file mode 100755 index 0000000..0b24095 --- /dev/null +++ src/utils/qa/userCount @@ -0,0 +1,6 @@ +#!/bin/bash +export HGDB_CONF=$HOME/.hg.conf +DISTINCT=`/cluster/bin/x86_64/hgsql -h genome-centdb -Ne 'select distinct email from gbMembers' hgcentral 2> ~/bin/userCountErrorLog | wc -l` +#TOTAL=`/cluster/bin/x86_64/hgsql -h genome-centdb -Ne 'select email from gbMembers' hgcentral 2> ~/bin/userCountErrorLog | wc -l` +DATE=`date "+%s %F"` +printf "%s\t%d\n" "$DATE" "$DISTINCT" >> /hive/data/inside/wwwstats/RR/gbMembersCount.txt