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
vriendelijke groet,
Richard van Denzel
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
leandro benatti
Sent: dinsdag 24 mei 2011 15:57
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Select works in 5.5 but not in 6.x
Hi all,
Try use the command
Works on 6.2.2.0 Windows server.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
leandro benatti
Sent: Tuesday, May 24, 2011 9:57 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Select works in 5.5 but not in 6.x
Hi all,
Try use the command
Hi,
Can anyone explain why this select command works fine in TSM 5.5 and not in TSM
6.x?
Even if all information are still their.
select nodes.domain_name, nodes.node_name, auditocc.backup_mb from
nodes,auditocc where nodes.node_name=auditocc.node_name order by
Of
Christian Svensson
Sent: Monday, December 20, 2010 9:58 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Select works in 5.5 but not in 6.x
Hi,
Can anyone explain why this select command works fine in TSM 5.5 and not in TSM
6.x?
Even if all information are still their.
select nodes.domain_name
@VM.MARIST.EDU
Date:
12/20/2010 10:16 AM
Subject:
Re: [ADSM-L] Select works in 5.5 but not in 6.x
Sent by:
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
Known bug.
You can't do joins in 6.x (usually you don't get errors, you just get no
data, which is worse).
Occasionally it works, but don't rely
: Monday, December 20, 2010 08:36
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Select works in 5.5 but not in 6.x
FWIW, I jumped into dsmadmc on my 6.2.2.0 server and issued the select.
This is what I got:
tsm: SUNselect nodes.domain_name, nodes.node_name, auditocc.backup_mb from
nodes,auditocc where