Hi all, Try use the command line:
select ENTITY,cast(float(sum(bytes))/1024/1024/1024 as decimal(14,2)) from summary where (start_time between '2011-04-23 00:00:00' and '2011-05-22 23:59:59') and (summary.activity='BACKUP' or summary.activity='ARCHIVE') group by ENTITY +---------------------------------------------------------------------- |This was sent by [email protected] via Backup Central. |Forward SPAM to [email protected]. +----------------------------------------------------------------------
