ADSM-L

Re: sql query required

2006-07-17 07:44:44
Subject: Re: sql query required
From: Richard Sims <rbs AT BU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 17 Jul 2006 07:43:05 -0400
On Jul 17, 2006, at 7:33 AM, Sujay Dinakar R. wrote:

Dear all,

  can any one please tell me how to find the size of the archived
files in a particular month.

  by issuing the command
  select * from Archives where ARCHIVE_DATE > '2006-01-01 08:00:00'
AND ARCHIVE_DATE < '2006-02-01 18:00:00'

  i could able to get the list of files and file ID but i could not
able to get the size coloum.

  can any one know how to get the size of the archived files.

  Best Regards
  sujay dinakar r

File sizes are available only via client queries ... 'dsmc query
archive' and the GUI.

   Richard Sims

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