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' and month(Start_time)= month(current date - 1 month) Alternatively, you could turn on accounting, and sum all the archived bytes in the accounting data file for the month. Regards Steve Steve Harris AIX and TSM Admin Brisbane Australia -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Sujay Dinakar R. Sent: Monday, 17 July 2006 10:18 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] sql query required 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 > 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.
