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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bell, Charles (Chip)
Sent: Thursday, January 03, 2008 4:10 PM
To: ADSM-L AT VM.MARIST DOT EDU
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.
|
