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" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED]
