#!/bin/bash

#this is the OLD method - if you want lists based on cmon pages use generate_lists.bash in stats dir

#simple example where customer is demo and password is demopw and forty-first branch machine labels start with FFP:
#mysql -u gvu_demo -pdemopw gvdb_demo --silent --skip-column-names -e 'select workstation from maps WHERE workstation LIKE "FFP%" ORDER BY workstation' >> forty-first.list

. /var/www/html/groovix/stats/my_config.bash

echo -n > $LISTPATH/all.list
echo 'USERPATTERN=^g' > $LISTPATH/all-guests.list

for INDEX in ${!BR[*]} ; do
   #start with blank list
   echo -n > $LISTPATH/${BR[$INDEX]}.list
   echo mysql -u $MYUSERPREPEND$MYVERSION -p$MYPWPREPEND$MYPASS $MYDBPREPEND$MYVERSION --silent --skip-column-names -e "select workstation from maps WHERE workstation LIKE \"${BP[$INDEX]}%\" ORDER BY workstation" \>\> $LISTPATH/${BR[$INDEX]}.list
        mysql -u $MYUSERPREPEND$MYVERSION -p$MYPWPREPEND$MYPASS $MYDBPREPEND$MYVERSION --silent --skip-column-names -e "select workstation from maps WHERE workstation LIKE \"${BP[$INDEX]}%\" ORDER BY workstation"   >> $LISTPATH/${BR[$INDEX]}.list
   cat $LISTPATH/all-guests.list $LISTPATH/${BR[$INDEX]}.list > $LISTPATH/${BR[$INDEX]}-guests.list
done

