Bruce, You could do a group by node_name at the end of your select statement.
Best Regards, _________________________________________________________ email: ron.delaw...@us.ibm.com Storage Services Offerings From: "Kamp, Bruce (Ext)" <bruce.k...@alcon.com> To: ADSM-L@VM.MARIST.EDU Date: 03/09/15 12:46 Subject: [ADSM-L] Select Statement Help Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 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 get this: Node Name HL_NAME BACKUP DATE STATE --------------------- ------------------------------------------------------------- ------------ -------------- XYZ_TDP // 2009-08-17 ACTIVE_VERSION XYZ_TDP // 2009-09-13 ACTIVE_VERSION XYZ_TDP // 2009-09-14 ACTIVE_VERSION XYZ_TDP // 2009-09-15 ACTIVE_VERSION XYZ_TDP // 2009-09-16 ACTIVE_VERSION What I really want is something like this: Node Name HL_NAME BACKUP DATE STATE --------------------- ------------------------------------------------------------- ------------ -------------- XYZ_TDP // 2009-08-17 ACTIVE_VERSION ABC_TDP // 2009-09-13 ACTIVE_VERSION 123_TDP // 2009-09-14 ACTIVE_VERSION Is this possible ? Thanks, Bruce Kamp TSM Administrator (817) 568-7331
