Hello everyone, I have an sql statement that finds out how much data was backed up per node and I was just wondering if there would be a way to modify this so that I could see the total amount of data backed up per domain instead? Here is the sql statement that I currently use:
select left(entity,10) as node_name, date(start_time) as date, cast(activity as varchar(8)) as activity, time(start_time) as start, time(end_time) as end,cast(bytes/1024/1024 as decimal(6,0)) as mb, cast(affected as decimal(7,0)) as files,cast(successful as varchar(3)) as success from summary where start_time>=current_timestamp-1 day and activity='BACKUP' order by node_name Thank you in advance for any help that you can provide! ******************************** Joni Moyer Highmark Storage Systems, Storage Mngt Analyst III Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED] ********************************
