[no subject]

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:SBach AT MGE DOT COM]
Sent: Friday, June 20, 2003 12:49 PM
To: ADSM-L AT VM.MARIST DOT EDU
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 sbach AT mge DOT com