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
