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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s