|
Re: select statement for checking filespace backup status
2001-10-15 10:52:32
|
Subject: |
Re: select statement for checking filespace backup status |
|
From: |
"Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT COM> |
|
Date: |
Mon, 15 Oct 2001 16:49:48 +0200 |
Hi Joseph!
I personally use the following SQL statements in a script which runs on a
daily basis:
select left(node_name,16) as node_name, left(filespace_name,32) as
file_space, backup_end, current_date - date(backup_end) as last_backup_days
from filespaces where (days(current_date) - days(backup_end) >= 2) and
node_name not in ('EXCLUDED NODE 1','EXCLUDED NODE 2')
It reports all filespaces that haven't been backed up for 2 days or more.
Hope this is what you want.
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
|
|
|
