Try something like this.
dsmadmc -se=$i -id=$adminid -password=$adminpwd -noc -tab -dataonly=yes
<<EOD
select backups.node_name, -
backups.filespace_name, -
backups.filespace_id, -
backups.state, -
backups.type, -
backups.hl_name, -
backups.ll_name, -
backups.backup_date, -
contents.FILE_NAME, -
contents.FILE_SIZE -
from backups,contents -
where backups.OBJECT_ID = contents.OBJECT_ID -
and backups.node_name = 'YOURNODE'
EOD
-----------------------------------------
The information contained in this message is intended only for the personal and
confidential use of the recipient(s) named above. If the reader of this message
is not the intended recipient or an agent responsible for delivering it to the
intended recipient, you are hereby notified that you have received this
document in error and that any review, dissemination, distribution, or copying
of this message is strictly prohibited. If you have received this communication
in error, please notify us immediately, and delete the original message.
