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

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*select\s+statement\?\s*$/: 4 ]

Total 4 documents matching your query.

1. select statement? (score: 1): Author: Alexander Lazarevich <alazarev AT ITG.UIUC DOT EDU>; Date: Mon, 4 Aug 2003 14:23:15 -0500; Hi, TSM 5.1.6.5 on windows 2K server. I'm trying to make a command script that will tell me how many filespaces have a BACKUP_END greater than 1 day. Then I want it to email those results to me. That; /lists/html/ADSM-L/2003-08/msg00062.html (9,478 bytes)
2. Re: select statement? (score: 1): Author: Alex Paschal <AlexPaschal AT FREIGHTLINER DOT COM>; Date: Mon, 4 Aug 2003 12:28:01 -0700; Alex, For number of file spaces that haven't backed up: select count(*) from filespaces where backup_end<current_timestamp-1 day For total number of filespaces: select count(*) from filespaces For na; /lists/html/ADSM-L/2003-08/msg00063.html (10,174 bytes)
3. Re: select statement? (score: 1): Author: Andrew Raibeck <storman AT US.IBM DOT COM>; Date: Mon, 4 Aug 2003 13:34:56 -0600; If you also want to capture file spaces that have no completion date, consider adding "or backup_end is null" to the "where" criterion, i.e.: ... where backup_end < current_timestamp - 1 day or backu; /lists/html/ADSM-L/2003-08/msg00064.html (11,046 bytes)
4. Re: select statement? (score: 1): Author: Alexander Lazarevich <alazarev AT ITG.UIUC DOT EDU>; Date: Mon, 4 Aug 2003 14:46:51 -0500; TSM rocks. And so do you guys. Thanks. Alex; /lists/html/ADSM-L/2003-08/msg00065.html (12,354 bytes)

Current List: 1 - 4
Page: [1]