Hello Fran First thanks for the script .
What is strange is for activity BACKUP I got in Sub_entity the name of the machine but for activity RESTORE the Sub_entity is null ! Regards Robert -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Francisco Molero Sent: Sunday, September 25, 2016 12:42 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] VM restore output 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 <dem...@gmail.com> Para: ADSM-L@VM.MARIST.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 <rou...@univ.haifa.ac.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
