Bonjour

J'ai ce script en ksh, appelé par du PHP que je dois transformer en .bat à lancer par VB.NET.

Pour info "qsexport" et "qsquery" sont des commandes Quota server pour lancer un .exe du meme nom.

Autre truc : je dois désormais gérer les serveurs de facon dynamique (liste des serveurs stockés dans une base Oracle 9i), donc je pense qu'une boucle conviendrait mieux, mais je sais pas non plus comment faire communiquer le batch et oracle.

Quelqu'un peut m'aider svp?

#
if [ -e "./tmp.txt" ]
then
echo "inprogress"
exit 0
fi

echo 1 > ./tmp.txt

qsexport serveur01 | grep \\\\ | awk -F"," ' { print $2","$28 } ' > ./list.txt
qsquery serveur01 "*" /C | grep \\\\ | awk -F"," '{ print ","$2","$3","$4 }' > ./quota.txt
paste -d \\0 ./list.txt ./quota.txt > ./tmp.txt

qsexport serveur02 | grep \\\\ | awk -F"," ' { print $2","$28 } ' > ./list.txt
qsquery serveur02 "*" /C | grep \\\\ | awk -F"," '{ print ","$2","$3","$4 }' > ./quota.txt
paste -d \\0 ./list.txt ./quota.txt >> ./tmp.txt

qsexport serveur03 | grep \\\\ | awk -F"," ' { print $2","$28 } ' > ./list.txt
qsquery serveur03 "*" /C | grep \\\\ | awk -F"," '{ print ","$2","$3","$4 }' > ./quota.txt
paste -d \\0 ./list.txt ./quota.txt >> ./tmp.txt

qsexport serveur04 | grep \\\\ | awk -F"," ' { print $2","$28 } ' > ./list.txt
qsquery serveur04 "*" /C | grep \\\\ | awk -F"," '{ print ","$2","$3","$4 }' > ./quota.txt
paste -d \\0 ./list.txt ./quota.txt >> ./tmp.txt

qsexport serveur05 | grep \\\\ | awk -F"," ' { print $2","$28 } ' > ./list.txt
qsquery serveur05 "*" /C | grep \\\\ | awk -F"," '{ print ","$2","$3","$4 }' > ./quota.txt
paste -d \\0 ./list.txt ./quota.txt >> ./tmp.txt

qsexport serveur06 | grep \\\\ | awk -F"," ' { print $2","$28 } ' > ./list.txt
qsquery serveur07 "*" /C | grep \\\\ | awk -F"," '{ print ","$2","$3","$4 }' > ./quota.txt
paste -d \\0 ./list.txt ./quota.txt >> ./tmp.txt

rm ./list.txt
rm ./quota.txt
rm ./recup_quota.txt
mv ./tmp.txt ./recup_quota.txt
rm ./tmp.txt


echo "ok"
exit 0