Hi, Shannon. You could try building a list of your nodes: node1 node2 node3
store it in a file, "nodes". Then create a shell script, something like the following. You may have to clean up some backslashes, I didn't check it. Oh, I'm assuming a Unix machine. If it's Windows, I'm sure you can find a way to port the concept. #!/usr/bin/ksh cat nodes | while read NODENAME; do print "query node \$NODENAME" print "select distinct(class_name) from backups where node_name=\'\$NODENAME\'" print "select distinct(class_name) from archives where node_name=\'\$NODENAME\'" done | dsmadmc -id=id -pa=password -out=myoutfile But that's going to take a long time. It may even kill your server. Also, it won't tell you if the mgmtclass is on an include/exclude list that is including nonexistant files. You would also have to check the include/exclude list of each client. Alex Paschal Freightliner, LLC (503) 745-6850 phone/vmail -----Original Message----- From: Shannon Bach [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 12:49 PM To: [EMAIL PROTECTED] Subject: Like many others on the list I inherited TSM after it was already set up. There are many Management classes defined that I am sure are not being used any longer. I would like to start cleaning these up if possible but I don't know how to find out if; 1. They are currently being used by a current node 2. If they are somehow tied to old nodes and/or files that have not expired Does anyone know of a script or select statement that would give me this information? I have played around a little bit with no luck. any feedback would be appreciated. Thanks, Shannon Bach Madison Gas & Electric Co. e-mail [EMAIL PROTECTED]
