ADSM-L
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

Re: [ADSM-L] Select Statement Help

2015-03-09 16:00:34
Subject: Re: [ADSM-L] Select Statement Help
From: Ron Delaware <ron.delaware AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 9 Mar 2015 12:57:20 -0700
Bruce,

You could do a group by node_name at the end of your select statement.
 

Best Regards,

_________________________________________________________
    
email: ron.delaware AT us.ibm DOT com
Storage Services Offerings

 



From:        "Kamp, Bruce (Ext)" <bruce.kamp AT ALCON DOT COM>
To:        ADSM-L AT VM.MARIST DOT EDU
Date:        03/09/15 12:46
Subject:        [ADSM-L] Select Statement Help
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>




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
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  [ADSM-L] Select Statement Help, Kamp, Bruce (Ext)
Next by Date:  Re: [ADSM-L] select * from backups + file size, Remco Post
Previous by Thread:  [ADSM-L] Select Statement Help, Kamp, Bruce (Ext)
Next by Thread:  Re: [ADSM-L] Select Statement Help, Hanover, Cameron
Indexes:  [Date] [Thread] [Top] [All Lists]