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

Output:

tsm: POSTBACK>run restore_list

Node Postback                                                         DATE      
       OPERATION                 GB
-------------------------------------                          -----------     
----------------               -----------
HAIFA_DATACENTER (VMPROXY2)                2016-09-22     RESTORE               
     100.0

T.I.A Regards