Personally, I find that filespaces are a good indicator. Generally, the backup_end should be more recent than backup_start. Backup_end should also generally be within the past day or it missed.
select count(distinct(node_name)) from filespaces where backup_end < (current_timestamp - (1 day)) Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -----Original Message----- From: Glass, Peter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 8:26 AM To: [EMAIL PROTECTED] Subject: reporting on backup successes/failures What would be the best way to produce a report that shows the number of client backup successes vs. failures, for a given day? Peter Glass Distributed Storage Management (DSM) Wells Fargo Services Company > * [EMAIL PROTECTED] >
