Toni, You could try
SELECT COUNT(LL_NAME) FROM BACKUPS - WHERE BACKUP_DATE>'2001-12-08 00:01' This will give you a figure which may be reasonably accurate, but what about expiration? Another approach might be to pull out into a spreadsheet the number of files backed up from daily query actives to build up running totals Toni Banire <[EMAIL PROTECTED]> on 01/07/2002 03:39:03 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: (bcc: John Naylor/HAV/SSE) Subject: daily backup Hello I am trying to generate a list of monthly files backed up. I come up with the select statement below which seems to be taking it's time (not sure if it's legal). Does anyone know of a better way generate a summary of the total no. of files backed up TIA Toni select count(contents.file_name), count(volumes.volume_name) from contents,volumes where volumes.volume_name=contents.volume_name and volumes.last_write_date = '2002-01-04 00:00' ********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **********************************************************************