I think the answer to this question is, "No" , but I am going to ask
anyway.

I want to make a listing of the management classes used by each client.

I have been asked to provide a list of applications that use longer than
our standard retention policy. TSM will not identify applications for
me, but I can look up Client/server names.

I know how to write an sql query against the backups table.  I have
queried particular node_names to see what management classes they use.
Thanks to instruction from W, I realize that the backups table is huge.
I tried to make a more efficient query by restricting the query to
Active objects of type File and running it on the TSM server with the
smallest DB, but it was still running when I came back from lunch.
        select distinct node_name, class_name from backups where
type='FILE' AND STATE='ACTIVE_VERSION'

Is there a smarter way to find this information out?  The owners of
these clients for the most part would have no idea and would be no help.

Thanks,
George Huebschman

"Let me get this straight.  You won't let us delete this node because
there is no one left who remembers what the machine used to do?"

IMPORTANT:  E-mail sent through the Internet is not secure. Legg Mason 
therefore recommends that you do not send any confidential or sensitive 
information to us via electronic mail, including social security numbers, 
account numbers, or personal identification numbers. Delivery, and or timely 
delivery of Internet mail is not guaranteed. Legg Mason therefore recommends 
that you do not send time sensitive 
or action-oriented messages to us via electronic mail.

This message is intended for the addressee only and may contain privileged or 
confidential information. Unless you are the intended recipient, you may not 
use, copy or disclose to anyone any information contained in this message. If 
you have received this message in error, please notify the author by replying 
to this message and then kindly delete the message. Thank you.