This actually isn't a very easy question to answer, and I'm not sure how useful this data would be. Files from a single node can be bound to multiple management classes, so you would have to check each file. If you really want to let your TSM database grind away for a while, you can try this, but be warned, it'll take quite a while. I've occasionally crashed TSM servers with big queries, and that might happen with this one.
select class_name, node_name from backups group by class_name, node_name I _THINK_ that'll work, but I didn't want to try it on my server. Good luck. Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -----Original Message----- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 2: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]
