ADSM-L

Re: [ADSM-L] select * from backups + file size

2015-03-09 14:09:51
Subject: Re: [ADSM-L] select * from backups + file size
From: "Rhodes, Richard L." <rrhodes AT FIRSTENERGYCORP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 9 Mar 2015 18:08:02 +0000
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.
<Prev in Thread] Current Thread [Next in Thread>