Use the b-trees: add node name and filespace name. select * from columns where tabname='BACKUPS' shuold show you (index_keyseq) where the b-trees are; use as many as you can but always the first one.
Hope this helps. ------ Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On May 15, 2009, at May 15, 2:43 PM, Huebschman, George J. wrote:
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.