Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*sql\s+query\s+required\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*sql\s+query\s+required\s*$/: 5 ]

Total 5 documents matching your query.

1. sql query required (score: 1): Author: "Sujay Dinakar R." <sujay_dinakar AT YAHOO DOT COM>; Date: Mon, 17 Jul 2006 04:33:16 -0700; 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 ARC; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-07/msg00243.html (11,105 bytes)
2. Re: sql query required (score: 1): Author: Richard Sims <rbs AT BU DOT EDU>; Date: Mon, 17 Jul 2006 07:43:05 -0400; 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 AR; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-07/msg00244.html (11,246 bytes)
3. Re: sql query required (score: 1): Author: "Sujay Dinakar R." <sujay_dinakar AT YAHOO DOT COM>; Date: Mon, 17 Jul 2006 05:18:12 -0700; thanks you richard. i was trying to see if possible to get the sizes at the server side. sujay dinakar r File sizes are available only via client queries ... 'dsmc query archive' and the GUI. Richard; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-07/msg00246.html (11,624 bytes)
4. Re: sql query required (score: 1): Author: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>; Date: Mon, 17 Jul 2006 09:34:04 -0400; 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 direc; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-07/msg00247.html (12,034 bytes)
5. Re: sql query required (score: 1): Author: Steve Harris <steve AT STEVENHARRIS DOT INFO>; Date: Mon, 17 Jul 2006 23:35:58 +1000; 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2006-07/msg00248.html (12,385 bytes)

Current List: 1 - 5
Page: [1]