Hi Robert,
this is my script for backup VM. 

SELECT start_time, end_time, TRANSLATE('a bc:de:fg', 
DIGITS(end_time-start_time), '_______abcdefgh_____',' ') as "ELAPTIME", 
activity, bytes/1048576 as MBYTES, entity, sub_entity as "Virtual Machine", 
successful FROM summary_extended WHERE activity='BACKUP' AND 
end_time>current_timestamp-24 hours and activity_details='VMware' order by 
sub_entity

This is my restore report
VM MACHINE      Data Mover      ELAPTIME   DATE    OPERATION  GBYTES  
SUCCESSFUL 
-------------   --------------  ----------------    -----------    -----------  
csimail                         CC_FORUM_DM     0 00:54:42 2016-09-23  RESTORE 
101.0    YES        
CLON-BACKUP33   CC_FORUM_DM3    0 00:00:02 2016-09-22  RESTORE 0.0        NO    
     
CLON-BACKUP32   CC_FORUM_DM3    0 00:13:32 2016-09-22  RESTORE 100.0    YES     
   
csipdc                          CC_FORUM_DM     0 00:42:28 2016-09-21  RESTORE 
102.0    YES        

In your case, sub_entity is empty??  

If you are using a version 6 of TSM it would be possible there were any bugs.. 
In version 7.1.5 it is working..
Regards, 

Fran.





      De: Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL>
 Para: ADSM-L AT VM.MARIST DOT EDU 
 Enviado: Domingo 25 de septiembre de 2016 18:44
 Asunto: Re: VM restore output
   
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 AT VM.MARIST DOT EDU] On Behalf Of 
Francisco Molero
Sent: Sunday, September 25, 2016 12:42 PM
To: ADSM-L AT VM.MARIST DOT 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 <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