dear Thomas, dear Richard, dear all, Thomas wrote: > To see when a file was deactivated use this - long running - SELECT statement: > SELECT HL_NAME, LL_NAME, DATE(BACKUP_DATE) as bkdate, DATE(DEACTIVATE_DATE) > AS DELDATE, CLASS_NAME FROM ADSM.BACKUPS WHERE STATE = 'INACTIVE_VERSION' AND > TYPE = 'FILE' AND NODE_NAME = 'UPPER_CASE_NAME' AND FILESPACE_NAME = > 'Case_Sensitive_Name'
that's what I had in mind :-) "long running" is quite understated :-D > This was taken from Richard Sims fabulous ADSM/TSM QuickFacts site at > http://people.bu.edu/rbs/ADSM.funcdir I didn't found something like above there. well, I think my SQL knowledge is too poor to concate the right terms ... @Richard: sure, the adminstrator of the client should have logfiles for more than 2 days, so he could answer this question by himself and with a carefully configured the size will not grow too much ;-) thanks & best regards, Bjørn > HTH > Thomas Rupp > > -----Ursprüngliche Nachricht----- > Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Bjørn > Nachtwey > Gesendet: Montag, 28. April 2008 12:45 > An: ADSM-L@VM.MARIST.EDU > Betreff: [ADSM-L] file status by server? > > > dear all, > > one of my customers has some problems with his server: the machine loses > data. unfortunately he does not know when it starts. > > he thought of lokking at the tsm-logs, but the client logs lasts only > two days, so he cannot says when the first data was deleted by his > machine. > > my question: > is there a way to query the TSM-DB when a certain file was marked as > deleted? > How can I query which files belonging to a node are going to get > expired? > > Thanks, > > Bjørn -- ######################################################################## Dipl.-Ing. Bjørn Nachtwey Technische Universität Carolo-Wilhelmina zu Braunschweig Gauss-IT-Zentrum (GITZ) -- Abteilung Server Hans-Sommer-Straße 65, 38106 Braunschweig Telephon: +49 (0)531 / 391 - 5535 TeleFax: +49 (0)531 / 391 - 5549 http://www.tu-braunschweig.de/it mailto: [EMAIL PROTECTED] mailto: [EMAIL PROTECTED] ######################################################################## PGP-Schluessel: http://www-public.tu-bs.de:8080/~nachtwey/bjoern_nachtwey.asc PGP-Fingerprint: B472 526A A903 4AEB 9269 EC0B 9CDE 7465 CE87 ########################################################################