> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf Of Andrew Raibeck
> Sent: Thursday, January 04, 2007 5:40 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: List of archives
> 
> Given this SELECT statement:
> 
> > select node_name,description from archives group by
> > node_name,description
> 
> The following is simpler:
> 
>    select distinct node_name, description from archives

You're absolutely right Andy. I should have thought
of that.

Kind regards,

Alexander

> 
> Best regards,
> 
> Andy
> 
> Andy Raibeck
> IBM Software Group
> Tivoli Storage Manager Client Development
> Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
> Internet e-mail: storman AT us.ibm DOT com
> 
> IBM Tivoli Storage Manager support web page:
> http://www.ibm.com/software/sysmgmt/products/support/IBMTivoli
> StorageManager.html
> 
> The only dumb question is the one that goes unasked.
> The command line is your friend.
> "Good enough" is the enemy of excellence.
> 
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/04/2007
> 09:30:48 AM:
> 
> > Hi,
> >
> > Something like this should provide a list of all archives:
> >
> > select node_name,description from archives group by
> > node_name,description
> >
> > But like you said it will probably take a very long
> > time to complete. Or bring down your server. (I've
> > seen that happen with heavy sql queries in TSM).
> > It seems that the client has a far more efficient
> > way of querying the server than the sql interface has.
> >
> > You might consider to leave out the 'group by' clause
> > and redirect the output to a text file. Then import
> > this file into a database like Oracle or DB2 and do
> > your query there.
> > The text file can get pretty big though (depending
> > on how many files have been archived).
> >
> > Regards,
> >
> > Alexander
> >
> > ------------------------------------------------------------
> > Alexander Verkooijen
> > Senior Systems Programmer
> > High Performance Computing
> > SARA Computing & Networking Services
> >
> >
> > > -----Original Message-----
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]
> > > On Behalf Of Geert De Pecker
> > > Sent: Thursday, January 04, 2007 4:27 PM
> > > To: ADSM-L AT VM.MARIST DOT EDU
> > > Subject: List of archives
> > >
> > > Hi,
> > >
> > > I was wondering if there exists a tsm command to get a list of all
> > > existing archives by description, node, ...
> > >
> > > Intention is to get a list of all the archives that have been
> > > taken. Not
> > > to get the full file list. If found some SQL examples,
> > > but they take incredibly long to process. When, from the
> > > client GUI, one
> > > asks the existing archives (via "Delete Archives"),
> > > the list pops up immediately. Can we get the list from the server?
> > >
> > > Thanks,
> > >
> > > Geert
> > >
>