Hello All!
I tried to run the following select statement to find out how much data is
backed up for each NAS filesystem, but it times out every time when I run
it. Do I have incorrect syntax? Thank you in advance!
select summary.entity as "Server",date(summary.start_time) as
"Date",filespaces.filespace_name as "Filespace",time(summary.start_time) as
"Start",time(summary.end_time) as
"End",cast(substr(cast(summary.end_time-summary.start_time as
char(20)),3,8) as char(8)) as "Duration",summary.examined as
"Examined",summary.affected,summary.failed,cast(summary.bytes/1024/1024 as
decimal(6,0)) as "MB",summary.successful from summary,filespaces where
start_time>=current_timestamp - 24 hours and activity='NAS Backup' order by
summary.entity
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
|