46-70-325 1577
E-mail: christian.svens...@cristie.se
Skype: cristie.christian.svensson
Från: ADSM: Dist Stor Manager [ads...@vm.marist.edu] för Shawn Drew
[shawn.d...@americas.bnpparibas.com]
Skickat: den 22 oktober 2009 21:13
Till: ADSM-L@VM.MARIST.EDU
Ämne: Re: SV: [ADSM-L] S
___
Shawn Drew
Internet
c...@cmoldrup.dk
Sent by: ADSM-L@VM.MARIST.EDU
10/22/2009 02:48 PM
Please respond to
ADSM-L@VM.MARIST.EDU
To
ADSM-L
cc
Subject
[ADSM-L] SV: [ADSM-L] SV: [ADSM-L] "group by" assistance.
Hi Shawn
I am on 6.1
2009-10-20
3.00 2009-10-21
3.00 2009-10-22
tsm: TEST1_SERVER1>
-Oprindelig meddelelse-
Fra: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] På vegne af Shawn
Drew
Sendt: 22. oktober 2009 16:40
Til: ADSM-L@VM.MARIST.EDU
Emne: Re: [ADSM-L
t by: ADSM-L@VM.MARIST.EDU
10/22/2009 10:39 AM
Please respond to
ADSM-L@VM.MARIST.EDU
To
ADSM-L
cc
Subject
Re: [ADSM-L] SV: [ADSM-L] "group by" assistance.
That didn't work for me. What version of TSM do you have?
Regards,
Shawn
L] SV: [ADSM-L] "group by" assistance.
Hi Shawn
select sum(CAST((bytes/1024/1024/1024) as decimal(8,2))) AS "GB",
cast(end_time as date) as "Date" from summary where activity='STGPOOL
BACKUP' group by cast(end_time as date)
..would work
Regards
Carsten
Dist Stor Manager [mailto:ads...@vm.marist.edu] På vegne af Shawn
Drew
Sendt: 21. oktober 2009 23:20
Til: ADSM-L@VM.MARIST.EDU
Emne: [ADSM-L] "group by" assistance.
I'm having some trouble with the group by clause. It seems I can't group
data that has been "cast"
Shawn,
I think this is where you run into the limitations of the TSM SQL
implementation. I can't think of a way of achieving what you want.
Maybe Andy knows?
On 21 okt 2009, at 23:20, Shawn Drew wrote:
I'm having some trouble with the group by clause. It seems I can't
group
data that has bee
I'm having some trouble with the group by clause. It seems I can't group
data that has been "cast"ed
First start with:
select cast((bytes/1024/1024/1024) as decimal(8,2)) AS "GB", cast(end_time
as date) as "Date" from summary where activity='STGPOOL BACKUP'
1794.26
