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 get dangerous."
--Darkwing Duck

On Mar 9, 2015, at 3:42 PM, Kamp, Bruce (Ext) <bruce.kamp AT ALCON DOT 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