Jim, Yes, but... The sql table for backups is very large and selects against it are very resource intensive. If it is possible to do, the Client query backup command is more efficient.
You did not say what version of TSM Server and what OS you have. George Huebschman Storage Support Administrator Legg Mason, LMTS "When you have a choice, spend your money where you would want to work if it was your only choice." -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Jim Davis Sent: Friday, September 09, 2011 3:48 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] querying client backups from the server? Is there some way (SQL or otherwise) to get the effect of running 'dsmc query backup /some/path' on a client, but actually running the command on the TSM server instead? -- Jim Davis Biotechnology Computing Facility Arizona Research Labs 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.