Thanks for the help!
This what I ended up with.

SELECT CAST((NODE_NAME) AS CHAR(20)) AS "Node Name",CAST(MIN(BACKUP_DATE) AS 
DATE) AS "BACKUP DATE" FROM BACKUPS WHERE NODE_NAME LIKE '%_TDP' AND 
STATE='ACTIVE_VERSION' AND CLASS_NAME LIKE 
'%DB%' AND BACKUP_DATE < '2015-02-01' AND FILESPACE_NAME NOT LIKE '%$%' GROUP 
BY NODE_NAME


Bruce Kamp
TSM Administrator
(817) 568-7331


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Hanover, Cameron
Sent: Tuesday, March 10, 2015 11:05 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Select Statement Help

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