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 chano...@umich.edu "Let's get dangerous." --Darkwing Duck On Mar 9, 2015, at 3:42 PM, Kamp, Bruce (Ext) <bruce.k...@alcon.com> wrote: > 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
