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.

#!/bin/sh
while read host
do
  ssh $host <<"__HERE"
    for i in `lslpp -l |grep tsm`
    do
      lslpp -Lc $i |grep -v State |tr ':' ',' |awk -F, '{print $2, "," , $3}'
    done
__HERE
done <server_list.txt > ./test.csv
chmod 644 test.csv

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

Please check if this helps:

for i in `cat serverlist`; do ssh $i "for i in \`lspv | awk '{print \$1}'\`; do echo \$i; done"; done