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:[email protected]] On Behalf Of Hanover, Cameron Sent: Tuesday, March 10, 2015 11:05 AM To: [email protected] 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 [email protected] "Let's get dangerous." --Darkwing Duck On Mar 9, 2015, at 3:42 PM, Kamp, Bruce (Ext) <[email protected]> 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
