Works on 6.2.2.0 Windows server. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of leandro benatti Sent: Tuesday, May 24, 2011 9:57 AM To: [email protected] Subject: [ADSM-L] Select works in 5.5 but not in 6.x
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]. +----------------------------------------------------------------------
