Hello All! I have this finally working, but I was wondering if there is a way to shorten the width of the columns so that they can all fit on one line? And also, the customer has requested that the successful column be changed to completed, missed or failed. I didn't think this was possible unless I join 2 tables and then produce the same output. Is this a correct assumption? Thanks!
ANS8000I Server command: 'select entity as node_name, date(start_time) as date, cast(activity as varchar(10)) as activity, time(start_time) as start, time(end_time) as end, cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as decimal(7,0)) as files, successful from summary where start_time>=current_timestamp - 1 day and (entity like 'HM%' or entity like 'PAB%' or entity like 'VMS%' or entity like 'GEOHMKLG%' ) and activity='BACKUP' order by successful, node_name' NODE_NAME DATE ACTIVITY START END MEGABYTES FILES SUCCESSFUL ------------------ ---------- ---------- -------- -------- --------- --------- ------------------ HMCH1021 2005-02-09 BACKUP 19:12:14 19:22:03 572 2266 YES HMCH1028 2005-02-09 BACKUP 19:08:53 19:13:37 381 2063 YES HMCH1147 2005-02-09 BACKUP 19:12:13 19:42:06 384 2157 YES HMCH1150 2005-02-09 BACKUP 19:10:29 19:17:45 70 329 YES HMCH1160 2005-02-09 BACKUP 19:12:18 19:15:14 281 1987 YES HMCH1161 2005-02-09 BACKUP 19:09:25 19:13:47 187 221 YES ******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ********************************
