On Thursday 23 August 2007, Shawn Drew wrote:
> We have a request to provide the first day backups were run for a list of
> nodes.  The registration date isn't good, as there is a
> several day lag from registration to first backup.
> These dates are older than the age of the event and activity log.  Can
> anyone suggest a select statement for this?
You can try to run the sql
select NODE_NAME, BACKUP_DATE from backups order by backup_data where
NODE_NAME='node'

I suggest scripting this and send the output to a logfile.  The file with the
oldest backup_date will give you an idea of the first backup.  This can take
a long time to complete !!


Stef