Hello - I wrote the following select statement (with a lot of plagiarism).
/* --- Query Summary Table ---- */ select cast(entity as varchar(12)) as "Node Name", \ cast(activity as varchar(10)) as Type, \ cast(affected as decimal(7,0)) as files, \ cast(bytes/1024/1024 as decimal(12,4)) as "Phy_MB" \ from summary where end_time>=timestamp(current_date -1 days, '09:00:00') \ and end_time<=timestamp(current_date, '08:59:59') \ and (activity='BACKUP' or activity='ARCHIVE') \ order by "Node Name" The problem is, if a node performed 10 backups and 5 archives over the 24 hour period there are 15 lines for that node in the output, 10 for backup and 5 for archive. Is there a way I can add the affected columns and bytes column for a node which has activity=BACKUP and again for those with activity=ARCHIVE ? Basically, what I want is at most 2 lines per node... 1 line can be the sum of affected files and bytes for all backup activities And the other line for that node can be the sum of affected files and bytes for all ARCHIVE activities. I think I'm over my head. Regards, Denis L. L'Huillier 212-647-2168
