Hello,

try to select from the SUMMARY_EXTENDED table.

Efim


> 25 сент. 2016 г., в 10:26, Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL> 
> написал(а):
> 
> 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