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