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
|