Hello Everyone!
I am trying to create a select statement that will summarize NAS backups,
but when I run this command I get the following output. Is there a way to
find out what filesystem it had backed up? That is the last piece of what
I need for this report and I can't figure out how where that info. would
come from. Thank you in advance for your help!
select entity as "Admin Task",date(start_time) as "Date",time(start_time)
as "Start",time(end_time) as "End",cast(substr(cast(end_time-start_time as
char(20)),3,8) as char(8)) as "Duration", schedule_name as
"Schedule",examined as "Examined",affected,failed,cast(bytes/1024/1024 as
decimal(6,0)) as "MB",successful from summary where
start_time>=current_timestamp - 24 hours and activity not in ('ARCHIVE')
and activity='NAS Backup' order by entity
Admin Task: NAS_SERVER_2
Date: 2005-04-20
Start: 19:00:17
End: 19:01:53
Duration: 00:01:36
Schedule:
Examined: 0
AFFECTED: 0
FAILED: 0
MB: 42
SUCCESSFUL: YES
Admin Task: NAS_SERVER_2
Date: 2005-04-20
Start: 19:03:11
End: 19:06:05
Duration: 00:02:54
Schedule:
Examined: 0
AFFECTED: 0
FAILED: 0
MB: 0
SUCCESSFUL: YES
Admin Task: NAS_SERVER_2
Date: 2005-04-20
Start: 19:06:06
End: 19:09:07
Duration: 00:03:01
Schedule:
Examined: 0
AFFECTED: 0
FAILED: 0
MB: 37
SUCCESSFUL: YES
Admin Task: NAS_SERVER_2
Date: 2005-04-20
Start: 19:09:07
End: 19:12:01
Duration: 00:02:54
Schedule:
Examined: 0
AFFECTED: 0
FAILED: 0
MB: 38
SUCCESSFUL: YES
Admin Task: NAS_SERVER_2
Date: 2005-04-20
Start: 19:12:01
End: 19:14:48
Duration: 00:02:47
Schedule:
Examined: 0
AFFECTED: 0
FAILED: 0
MB: 0
SUCCESSFUL: YES
Admin Task: NAS_SERVER_2
Date: 2005-04-20
Start: 19:14:48
End: 19:17:35
Duration: 00:02:47
Schedule:
Examined: 0
AFFECTED: 0
FAILED: 0
MB: 0
SUCCESSFUL: YES
Admin Task: NAS_SERVER_2
Date: 2005-04-20
Start: 19:17:35
End: 19:20:30
Duration: 00:02:55
Schedule:
Examined: 0
AFFECTED: 0
FAILED: 0
MB: 0
SUCCESSFUL: YES
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
|