Hello All!
I am trying to run the following command: 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",number,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='NAS Backup' order by entity
And I received the following results when I issue a dsmadmc and output it
to a file. Is there a way to have this output appear on either one line or
have each line of output on a new line so that it will look like this: Any
help is appreciated!
admin task: NAS_SERVER_2
date: 2005-05-10
start: 07:47:21
end: 07:49:20
duration: 00:01:59
NUMBER: 5917
examined: 0
AFFECTED: 0
FAILED: 0
MB: 46
SUCCESSFUL: YES
admin task date start end duration
NUMBER examined AFFECTED
FAILED MB SUCCESSFUL
------------------ ---------- -------- -------- --------
----------- -------------------- --------------------
-------------------- -------- ------------------
NAS_SERVER_2 2005-05-10 07:47:21 07:49:20 00:01:59
5917 0 0
0 46 YES
NAS_SERVER_2 2005-05-10 07:47:21 07:51:41 00:04:20
5919 0 0
0 0 NO
NAS_SERVER_2 2005-05-10 07:47:21 07:51:46 00:04:25
5920 0 0
0 0 NO
NAS_SERVER_2 2005-05-10 07:47:21 07:54:56 00:07:35
5918 0 0
0 0 NO
NAS_SERVER_2 2005-05-10 07:47:22 07:51:49 00:04:27
5921 0 0
0 0 NO
NAS_SERVER_2 2005-05-10 07:47:22 07:51:53 00:04:31
5922 0 0
0 0 NO
NAS_SERVER_2 2005-05-10 07:47:22 08:21:12 00:33:50
5925 0 0
0 0 NO
NAS_SERVER_2 2005-05-10 07:47:22 08:23:19 00:35:57
5923 0 0
0 41679 YES
NAS_SERVER_2 2005-05-10 07:47:22 08:25:37 00:38:15
5924 0 0
0 0 YES
NAS_SERVER_2 2005-05-10 07:47:23 08:21:16 00:33:53
5926 0 0
0 0 NO
NAS_SERVER_2 2005-05-10 07:47:23 08:21:20 00:33:57
5927 0 0
0 0 NO
NAS_SERVER_2 2005-05-10 07:47:23 08:32:14 00:44:51
5928 0 0
0 4020 YES
NAS_SERVER_2 2005-05-10 07:47:23 08:41:51 00:54:28
5929 0 0
0 9553 YES
NAS_SERVER_2 2005-05-10 07:47:23 08:54:58 01:07:35
5930 0 0
0 12239 YES
NAS_SERVER_2 2005-05-10 07:47:24 07:53:02 00:05:38
5933 0 0
0 0 NO
NAS_SERVER_2 2005-05-10 07:47:24 07:53:06 00:05:42
5934 0 0
0 0 NO
NAS_SERVER_2 2005-05-10 07:47:24 09:09:57 01:22:33
5931 0 0
0 13764 YES
NAS_SERVER_2 2005-05-10 07:47:24 09:15:29 01:28:05
5932 0 0
0 710 YES
NAS_SERVER_2 2005-05-10 07:47:25 07:53:09 00:05:44
5936 0
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
|