Hello,

how do you take care of selective backups? They are not reflected in the
"date of last backup" field. So, additionally to what has been suggested
by Phil Bone, I usually verify that there are no younger backups in the
filespace by looking through the backups table:

select min(days(current_timestamp)-days(backup_date))  -
  from backups where node_name='$1' and filespace_name='$2'

This query is expensive, so I only do it for those candidates determined
by Phil Bone's query. If you can ignore selective backups (e.g. because of
your service level aggreements), fine. In my case, I detected several
filespaces containing actual backups which otherwise would have been
deleted.

Cleary, Leisa writes:
 > Hello *SMers-
 >
 > In our current environment we are backing up ~30,000 Desktop & Laptop
 > devices to NT boxes with 3.1.0.6 on both the clients and the server. As you
 > might imagine the cleanup & deletion of Filespaces/Nodes for inactive
 > devices is a real pain in the backside.
 >
 > I was able to write a script to run from a UNIX box to delete the Version 2
 > Filespaces because I was able to "q fil" on a set pattern. V2 used the HD
 > name as the filespace name, V3.1.06 uses the computername.
 >
 > My plea is this:
 >
 > Has anyone been able to write a select statement that creates an output file
 > where the "date of last backup completed" is greater than X# of days? (In
 > our case it is 180 days)
 >
 > The closest statement I can come up with is:
 > Select Node_Name, Filespace_Name, Backup_End from Filespaces
 >
 > I get an output file but can not seem to add any additional parameters that
 > would provide the same information within a certain date range. There does
 > not appear to be a query that give the # of days since last backup in
 > integer format.
 >
 > Any and ALL help is greatly appreciated. And Yes, home directories on file
 > servers has been a dream of ours for a couple of years now.......
 >
 >
 > Leisa (Cleary) Ammerall
 > Technical Analyst
 > ADSM/Enterprise Storage Management
 > SDN # 8 435 4786
 > (603) 245-4786
 > 1-800-222-9206 X54786
 > leisa.cleary AT libertymutual DOT com

--
Reinhard Mersch                        Westfaelische Wilhelms-Universitaet
Reinhard Mersch                        Westfaelische Wilhelms-Universitaet
Zentrum fuer Informationsverarbeitung - ehemals Universitaetsrechenzentrum
Roentgenstrasse 9-13, D-48149 Muenster, Germany      Tel: +49(251)83-31583
E-Mail: mersch AT uni-muenster DOT de                       Fax: 
+49(251)83-31653