Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+Select\s+Statement\s+Help\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+Select\s+Statement\s+Help\s*$/: 8 ]

Total 8 documents matching your query.

1. [ADSM-L] Select Statement Help (score: 1): Author: "Kamp, Bruce (Ext)" <bruce.kamp AT ALCON DOT COM>; Date: Mon, 9 Mar 2015 19:42:13 +0000; I am found a couple TDP SQL nodes that aren't inactivating there backups so TSM isn't expiring them... What I am trying to find is the oldest backup date for each server with a name like _TDP. I can; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2015-03/msg00053.html (12,104 bytes)
2. Re: [ADSM-L] Select Statement Help (score: 1): Author: Ron Delaware <ron.delaware AT US.IBM DOT COM>; Date: Mon, 9 Mar 2015 12:57:20 -0700; Bruce, You could do a group by node_name at the end of your select statement. Best Regards, _________________________________________________________ email: ron.delaware AT us.ibm DOT com Storage Ser; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2015-03/msg00054.html (16,362 bytes)
3. Re: [ADSM-L] Select Statement Help (score: 1): Author: "Hanover, Cameron" <chanover AT UMICH DOT EDU>; Date: Tue, 10 Mar 2015 12:04:47 -0400; This probably isn't completely right, but it might be a start: select node_name,hl_name,min(backup_date) from backups group by node_name,hl_name -- Cameron Hanover chanover AT umich DOT edu "Let's ge; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2015-03/msg00063.html (13,032 bytes)
4. Re: [ADSM-L] Select Statement Help (score: 1): Author: "Kamp, Bruce (Ext)" <bruce.kamp AT ALCON DOT COM>; Date: Tue, 10 Mar 2015 20:00:54 +0000; Thanks for the help! This what I ended up with. SELECT CAST((NODE_NAME) AS CHAR(20)) AS "Node Name",CAST(MIN(BACKUP_DATE) AS DATE) AS "BACKUP DATE" FROM BACKUPS WHERE NODE_NAME LIKE '%_TDP' AND STATE; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2015-03/msg00066.html (13,819 bytes)
5. [ADSM-L] Select Statement Help (score: 1): Author: "Lepre, James" <james.lepre AT SOLIXINC DOT COM>; Date: Tue, 24 Jun 2014 18:39:00 +0000; Hello Everyone - I am attempting miserably I might add to write a select statement that will produce a bunch of message found in the actlog. The problem I am having is grabbing the data from the last; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2014-06/msg00132.html (11,996 bytes)
6. Re: [ADSM-L] Select Statement Help (score: 1): Author: Rick Saylor <rsaylor AT AUSTINCC DOT EDU>; Date: Tue, 24 Jun 2014 14:19:22 -0500; James, What version of TSM? Your select statement will work in TSM 6.3 if you change "start_time" to "date_time". Please note that I did not verify the output, only that I got output. Rick I am attem; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2014-06/msg00133.html (12,791 bytes)
7. Re: [ADSM-L] Select Statement Help (score: 1): Author: "Lepre, James" <james.lepre AT SOLIXINC DOT COM>; Date: Tue, 24 Jun 2014 19:20:56 +0000; Version 7.1 James Lepre Infrastructure Support Specialist Solix, Inc. | 30 Lanidex Plaza West | Parsippany, NJ 07054 T: 973.581.5362 | F: 973.599.6544 www.solixinc.com | Solix on Facebook | Solix on; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2014-06/msg00134.html (13,516 bytes)
8. Re: [ADSM-L] Select Statement Help (score: 1): Author: white jeff <jeff.white3 AT BLUEYONDER.CO DOT UK>; Date: Tue, 24 Jun 2014 21:56:44 +0100; SELECT * FROM ACTLOG WHERE MSGNO IN (406,4952,4954,4958,4960,4957, 4970,4959,4961,4965,4963,4966,4967,4968,4969,4964, 4976, 4981) and; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2014-06/msg00135.html (12,709 bytes)

Current List: 1 - 8
Page: [1]