Bruce, You could do a group by node_name at the end of your select statement.
Best Regards, _________________________________________________________ email: [email protected] Storage Services Offerings From: "Kamp, Bruce (Ext)" <[email protected]> To: [email protected] Date: 03/09/15 12:46 Subject: [ADSM-L] Select Statement Help Sent by: "ADSM: Dist Stor Manager" <[email protected]> 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
