Bob -

Here is another macro you might find useful.

/*                                              */
/*                                              */
set sqldatetimeformat i
set sqldisplaymode w
set sqlmathmode r
commit
select count(*), type, left(description,96) as description -
  from adsm.archives -
   where node_name = %1 -
    group by type, description -
     order by description -
  >> 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:40 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