|
Re: Server Script
2001-05-29 13:18:42
|
Subject: |
Re: Server Script |
|
From: |
"Cook, Dwight E" <cookde AT BP DOT COM> |
|
Date: |
Tue, 29 May 2001 12:16:15 -0500 |
try slight variations of these...
Dwight
select node_name,filespace_name,cast((backup_end) as varchar(10)) as "Date"
from adsm.filespaces where (cast((current_timestamp-backup_end)day as
decimal(18,0))>2 )
select node_name,cast((lastacc_time) as varchar(10)) from adsm.nodes where
(cast((current_timestamp-lastacc_time)day as decimal(18,0))>2 )
|
|
|
