filespace reporting question
2001-12-12 10:21:52
Subject: |
filespace reporting question |
From: |
Joseph Dawes <jdawes AT CHUBB DOT COM> |
Date: |
Wed, 12 Dec 2001 10:18:44 -0500 |
Does anyone know how to use a select statement like the following but
instead of having it report on days have it report on hours? i.e. from now
-3 hours and less than 15 days.
select filespace_name as "Filespace", node_name as "Node",
select filespace_name as "Filespace", node_name as "Node",
days(current_date)-days(backup_end) as
"Last Backup",dayname(backup_end) as "Day
of Week" from filespaces where (days(backup_end) <
(days(current_date)-1) and
(days(current_date)- days(backup_end) <= 15))
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- filespace reporting question,
Joseph Dawes <=
|
|
|