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 <Toni.T.Banire AT GSK DOT COM> on 01/07/2002 03:39:03 PM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
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.
**********************************************************************
|