Hello,
I think you are not choosing the right table ( summary_extended ).
One example:
select cast((sub_entity) as char(36)) as "VM MACHINE", cast((entity) as
char(36)) as "Data Mover",DATE(start_time) as DATE, TRANSLATE('a bc:de:fg',
DIGITS(end_time-start_time), '_______abcdefgh_____',' ') as "ELAPTIME",
cast((activity) as char(15)) as OPERATION, CAST((bytes/1024/1024/1024) AS
decimal(8,1)) AS "GBYTES", successful from summary_extended WHERE (
activity='RETRIEVE' OR activity='RESTORE') and Sub_entity is not null ORDER BY
DATE DESC
I also think the VMware operations are only restores and not retrieves..
I hope this help you.
Fran
De: Dmitry Dukhov <demetr AT GMAIL DOT COM>
Para: ADSM-L AT VM.MARIST DOT EDU
Enviado: Domingo 25 de septiembre de 2016 10:34
Asunto: Re: VM restore output
nope
it’s impossible
names of vm are inside filespace
Dmitry
> On 25 Sep 2016, at 09:26, Robert Ouzen <rouzen AT univ.haifa.ac DOT il> wrote:
>
> Hello all
>
> Try to figure how to retrieve information of restore VM from TSM for VE.
>
> I wrote a script to retrieve , restore information but got for entity the
> name of the proxy and not the name of the VM machine.
>
> Here the script:
>
> SELECT cast((entity) as char(36)) as "Node Postback" , DATE(start_time) as
> DATE, cast((activity) as char(15)) as OPERATION,
> cast(float(SUM(bytes))/1024/1024/1024 as DEC(8,1)) as GB FROM summary WHERE
> activity='RETRIEVE' OR
> activity='RESTORE' GROUP BY entity,DATE(start_time),activity ORDER BY DATE
> DESC
>
>
> T.I.A Regards
|