Works on 6.2.2.0 Windows server.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
leandro benatti
Sent: Tuesday, May 24, 2011 9:57 AM
To: ADSM-L AT VM.MARIST DOT EDU
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 leandro.benatti AT tivit.com DOT br via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------