respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject:Complete a SQL statement
I have a domain admin who'd like to find obsolete filespaces. This is his
SQL script:
select
filespaces.node_name,filespaces.filespace_name,filespaces
To: [EMAIL PROTECTED]
cc:
Subject:Complete a SQL statement
I have a domain admin who'd like to find obsolete filespaces. This is his
SQL script:
select
filespaces.node_name,filespaces.filespace_name,filespaces.backup_end
from -
filespaces where (($1 < -
I have a domain admin who'd like to find obsolete filespaces. This is his
SQL script:
select filespaces.node_name,filespaces.filespace_name,filespaces.backup_end
from -
filespaces where (($1 < -
days(current_timestamp) - days(backup_end) or -
backup_end is null) and filespaces.node_name in (sel
