ADSM-L

Clean macro output

2004-01-13 04:00:41
Subject: Clean macro output
From: Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 13 Jan 2004 10:59:06 +0200
Hi To All

Did is a way to get a clean output from a macro just the result  for further
programming (want just the data ….)  I think I saw once an answer about 
this.
When running my macro I got in the output my select command and dash:

ANS8000I Server command: 'select entity as " " , cast(sum(bytes/1024/1024)
as decimal(10,3)) as " ", substr(cast(min(start_time) as char(26)),1,19) as
"                      ", cast(substr(cast(max(end_time)-min(start_time) as
char(20)),3,8) as char(8)) as "  " from summary where
date(Start_time)=current date - 1 days and time(start_time)>'18:00:00' and
activity='BACKUP' group by entity'

                                                                           
------------------     ------------     ----------------------     --------
EXCHANGE1                 57767.095     2004-01-12 22:07:18        01:37:19
HIGHLEARN2K                2750.848     2004-01-12 22:30:05        00:13:38

My TSM server version is 5.1.8 on Windows.

Regards
Robert Ouzen
E-mail: rouzen AT univ.haifa.ac DOT il

<Prev in Thread] Current Thread [Next in Thread>