Since queries on the backup table are very long running, maybe he would be better off turning on -VERBOSE onthe client and processing the DSMSCHED.LOG file. He would then get all the Expiring.. files, too. Plus it would give the size of the file(s). You could schedule a POSTSCHEDULEcmd to ftp the log file(s) to a central place where you could process them. Using PERL and maybe MySQL for history data would be a good (FREE!) combination. You could even go so far as coding up some web pages with PHP or Perl to access the data and build the pages to be served up with Apache...again FREE!!
Bill Boyer DSS, Inc. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of William F. Colwell Sent: Wednesday, March 20, 2002 12:17 PM To: [EMAIL PROTECTED] Subject: Re: Determining deleted files Scott, you can get the names of deleted files from SQL queries on the backups table, but with difficulty. I don't have any SQL to post here, but here is what you need to do. Select from the backups table where the deactivate date is the current date, assuming the backup happened between 00:00 and now when you are running the query. The results will be files deleted and files changed. Direct the output to a file 1. Then select from backups where backup_date is today and save the output to file 2. Compare files 1 & 2; anything in file 1 but not in file 2 is a deleted file. I suggest doing 2 selects and a compare because I don't think the tsm SQL processor would do this efficiently in one query, if it can do it at all. As for drastic size changes, I don't know of any way to determine that. The contents table reports sizes but usually it is the size of an aggregate and not the size of an individual file. At 08:30 AM 3/20/2002 -0700, you wrote: >I would like to use TSM to determine what files have been deleted from a >file server the previous day (or any given day if possible). >For example, on Monday TSM backed up the file bob.txt, but on Tuesday that >file had been deleted so it was not backed up. I would think that some sort >of query on Retain Only Version or Versions deleted may do it, but I don't >know how. > >A related question: Can I use TSM to determine if any files have been >drastically reduced in size? For example on Monday bob.txt was 100K when >backed up, but on Tuesday it was only 1K when backed up. I would not have a >specific file in mind, so this would also need to be done on all files. > >Thanks for any insight. > >Scott Foley ---------- Bill Colwell C. S. Draper Lab Cambridge Ma.
