Re: sql query required
2006-07-17 08:22:10
thanks you richard.
i was trying to see if possible to get the sizes at the server side.
sujay dinakar r
Richard Sims <rbs AT BU DOT EDU> wrote:
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
Regards
Sujay Dinakar .R
---------------------------------
Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail Beta.
|
|
|