I see no answer to this so there is one:
select distinct backups.node_name,domain_name,class_name -
from backups,nodes where backups.node_name=nodes.node_name

Zlatko Krastev
IT Consultant




Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:        Management Class/Node List

We need to make sure nothing else uses a manangement class before we
delete it and need to get a list of
all the manangement classes that are in use on the tapes. (we know what
is active on the server)

Is there a way I can list out all the unique  management classes and
what node uses them as well (as the volume if possible)

We have 190+ nodes spreading accross NT, 2000, AIX, Solaris, Linux,
SQL-Backtrack and MSSQL API.
so we can use the show version command.  This would need to be a batch
operation.

The server is RS/6000 AIX 4.3.3 Tivoli 4.1.4.0

Thanks in advance

Dana Jaeger
Hartford Hospital
Jaeger AT harthosp DOT org