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
C. S. Draper Lab
Cambridge, Ma.
[EMAIL PROTECTED]
--------------------------
In <[EMAIL PROTECTED]>, on 09/20/01
at 10:29 AM, "Brazner, Bob" <[EMAIL PROTECTED]> 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
