Re: Need a quick way to list off my archive descriptions

Bob - try this macro.  You are on the right track but you need the
distinct function.  I just ran it for a node with 20,000 archive files and it
took 15 seconds wallclock.

/*                                              */
/* macro file to select archive descriptions  for a user        */
/*                                              */
set sqldatetimeformat i
set sqldisplaymode w
set sqlmathmode r
commit
select DISTINCT left(description,96) as description, -
 left(node_name,12) as nodename, left(owner,12) as owner -
  from adsm.archives -
   where node_name = %1 -
  > e:\adsmcv3\sqllists\arcdesc
commit

--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <OF2773B327.3DB79306-ON86256ACC.007668C8 AT na.jci DOT com>, on 09/20/01
In <OF2773B327.3DB79306-ON86256ACC.007668C8 AT na.jci DOT com>, on 09/20/01
   at 10:29 AM, "Brazner, Bob" <Bob.Brazner AT JCI DOT COM> said:

>What SQL can I code to get a quick list of the archives I may have taken
>for a given node.  I'm interested in getting the unique "descriptions".  If
>I code
>select description from archives blah blah blah,
>it takes forever to product results.  Yet, I know the backup/restore gui is
>able to quickly display this information.  What's the trick?

>Bob Brazner
>(414) 524-2570