Remember, that is not limited to just a single management class...
     and do you want to know about backups or archives OR both? ? ?

     here is an example from junk on our test adsm server...
     NOTE, on this box there are 5 registered clients, only 3 have any
     backups and only 1 has archives

      select distinct node_name,class_name from adsm.backups

     NODE_NAME              CLASS_NAME
     ------------------     ------------------
     OKMAIX                 STANDARD
     OKMAIX                 DEFAULT
     TTCTST02               STANDARD
     XNJW00                 STANDARD
     XNJW00                 DEFAULT

      select distinct node_name,class_name from adsm.archives

     NODE_NAME              CLASS_NAME
     ------------------     ------------------
     TTCTST02               STANDARD
     TTCTST02               DEFAULT





______________________________ Reply Separator _________________________________
Subject: Node to mgmtclass report - SELECT
Author:  thaddad (thaddad AT COLUMBIAENERGYGROUP DOT COM) at unix,mime
Date:    4/1/99 11:49 AM


I received a response from some of you on a SELECT statement would show
NODE-to-MGMTCLASS relation
What I need now is a SELECT to show what MGMTCLASS(S) that a NODE has in use
(BOUND).?