Hi all, Does anyone have a good query to summarize the amount of data sent by a group of clients associated to a certain schedule, for all existing schedules, during the last 24 hours ? I tried this one : select ((sum(a1.bytes)/1024)/1024) as "MB backed up", a2.schedule_name from summary as a1, associations as a2 where a1.entity=a2.node_name and a1.activity='BACKUP' and cast((current_timestamp- a1.end_time )hours as decimal) <= 24 group by a2.schedule_name But I'm not really sure it works properly, as it seems to take ages to complete ... Basically, I try to find out how much backup data was sent on each of my primary stgpools last night, to size them properly and avoid unexpected migrations ... Thanks in advance ! Arnaud Brion
*********************************************************************** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ***********************************************************************
