ADSM-L

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

2015-03-09 17:09:34
Subject: Re: [ADSM-L] select * from backups + file size
From: Remco Post <r.post AT PLCS DOT NL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 9 Mar 2015 22:07:41 +0100
the object_ID is not unique in the backups table, so you might count data 
multiple times, up to 2000 files in a transaction, of 2 GB…. 2000 times 
inflated, 4 TB reported for 2 GB data.

> Op 9 mrt. 2015, om 19:08 heeft Rhodes, Richard L. <rrhodes AT FIRSTENERGYCORP 
> DOT COM> het volgende geschreven:
> 
> 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.

-- 

 Met vriendelijke groeten/Kind Regards,

Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622

<Prev in Thread] Current Thread [Next in Thread>