How do you do an ssh on a for statement. I have done ssh on individula lines of code before with no problems.

#!/usr/bin/ksh

cat server_list.txt | while read line
do
ssh $line "for i in `lslpp -l |grep tsm`
do
lslpp -Lc $i |grep -v State |tr ':' ',' |awk -F, '{print $2, "," , $3}'
done" > ./test.csv
done;
chmod 777 test.csv

this is what I get the data is blowing up ?

ksh: syntax error at line 3 : `tivoli.tsm.client.ba.32bit.base' unexpected

For starters, the multiple quotes in the string will be confusing it, change the choice of quotes in the awk.

Also, you don't need ksh for that, use a lighter shell (like /bin/sh)

You can avoid some of the quoting issues by using a here document. In my limited testing, this causes the remote hosts' MOTD messages to be displayed, which may or may not be a problem for you; depends on the SSH version and stuff like that, too, I guess.

Whatever you really want, chmod 777 is almost guaranteed to be wrong; I changed it to 644.

Looks to me like the redirection to test.csv was also in the wrong place (you would be overwriting it for each host) so I changed that as well.

Hi all, Thank you for all the advise.
Unfortunately there are some interesting interactions going on either from the shell or the ssh in relation to the while.
ERA I tried your suggestion and I got this. Tried the -t & -T but no go
"
Pseudo-terminal will not be allocated because stdin is not a terminal.
Pseudo-terminal will not be allocated because stdin is not a terminal.
Pseudo-terminal will not be allocated because stdin is not a terminal.
Pseudo-terminal will not be allocated because stdin is not a terminal.
"
smiling dragon I did try different varrations of the quoting but still something with while and the ssh.

Went with this for now but I will continue trying to get while to work.
Thanks for the feedback.

#!/usr/bin/ksh

for line in `cat server_list.txt`
do
echo $line
echo "***********"
ssh $line lslpp -Lc |grep tsm |awk -F : '{print $2, "\t", $3}'
echo
done