OPSI | software inventory | list clients having software versions installed

#!/bin/bash

red='33[0;31m'
purple='33[0;35m'
NC='33[0m' # No Color

echo "select name,version from SOFTWARE_CONFIG where name like '%$1%'group by name,version order by name,version;" | mysql -B -N -u${USER} -p${PASS} -D opsi | (
while read LINE; do
OIFS=$IFS;IFS=$'\t'
ARRAY=($LINE)
NAME="${ARRAY[0]}"
VERSION="${ARRAY[1]}"
echo -ne "${red}$NAME${NC} | ${purple}$VERSION${NC} | "
echo "select clientId from SOFTWARE_CONFIG where name = '$NAME' and version = '$VERSION';" | mysql -B -N -u${USER} -p${PASS} -D opsi | xargs echo -n
echo;echo
IFS=$OIFS
done
)

exit