Re: sql query required

2006-07-17 Thread Steve Harris
Sujay, If you keep your summary data for more than a month you could run a summary query on the first of each month (I can't access a server at the moment to test this so the field and function names may be wrong, but you'll get the idea) Select sum(bytes) from summary where activity='ARCHIVE' an

Re: sql query required

2006-07-17 Thread Prather, Wanda
Look at the TSM accounting records in dsmaccnt.log You must have accounting turned on; but all you have to do is enter: set accounting on TSM creates the dsmaccnt.log file in the server install directory. dsmaccnt.log is a comma-delimited file, easy to import into EXCEL. The fields are described

Re: sql query required

2006-07-17 Thread Sujay Dinakar R.
thanks you richard. i was trying to see if possible to get the sizes at the server side. sujay dinakar r Richard Sims <[EMAIL PROTECTED]> 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 >

Re: sql query required

2006-07-17 Thread Richard Sims
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'