Hello, try to select from the SUMMARY_EXTENDED table.
Efim > 25 сент. 2016 г., в 10:26, Robert Ouzen <rou...@univ.haifa.ac.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
