whoops I didn't read the whole request. Mind you, this select command is going to give you what mgmtclases are available to each of the nodes...
so: tsm: ADSM>select nodes.node_name, mgmtclasses.class_name from nodes, mgmtclasses where nodes.do main_name=mgmtclasses.domain_name NODE_NAME CLASS_NAME ------------------ ------------------ BFLOYD 10_DAY_RETENTION BFLOYD 30_DAY_RETENTION BFLOYD 5_DAY_RETENTION BFLOYD 60_DAY_RETENTION BFLOYD 90_DAY_RETENTION -----Original Message----- From: Prather, Wanda [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 2:44 PM To: [EMAIL PROTECTED] Subject: Re: SQL command Do you mean by domain? Nodes don't have management classes, files do.... -----Original Message----- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 3:40 PM To: [EMAIL PROTECTED] Subject: SQL command Looking for an SQL command that will show me nodes by management class. Can anyone help? Regards, Joe Wholey TGA Distributed Data Services Merrill Lynch Phone: 212-647-3018 Page: 888-637-7450 E-mail: [EMAIL PROTECTED]