Chip, Try the following: "select filespace_name,hl_name,ll_name,state from backups where node_name=<the_client>" Redirect to a file and search for what you are missing. If you are sure of the filesystem name (like /opt), add "...and filespace_name='/opt'" to limit the output.
Have a happy day! Neil Strand Storage Engineer - Legg Mason Baltimore, MD. (410) 580-7491 Whatever you can do or believe you can, begin it. Boldness has genius, power and magic. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bell, Charles (Chip) Sent: Thursday, January 03, 2008 4:10 PM To: [email protected] Subject: [ADSM-L] Missing File Query I am looking for the quickest way to find multiple files that were apparently deleted by a user. They would like to restore them, but do not know where they are (were). All I have to work with as a starting point is, the files are somewhere under '/opt/emageon/archive/dicom'. Is there a SQL select that I can run from the server side, dumping the output to a file I can parse? I tried a query from the client side, and apparently the client machine does not have enough memory to handle this: 'dsmc query backup -inactive /opt/emageon/archive/dicom/* > filerestore.txt' Please help! Thanks! God bless you!!! Chip Bell Network Engineer I IBM Tivoli Certified Deployment Professional Baptist Health System Birmingham, AL ----------------------------------------- Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information. 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.
