Symptoms
As Provider I see failed VPS backup tasks in POA Task Manager and I need to filter tasks for VPSs located on a particular Parallels Virrtuozzo Containers (PVC) Hardware Node.
Resolution
The information may be fetched from POA system database using the SQL query below:
SELECT t.task_id, t.name, t.status, ves.ve_host_id, ves.hw_host_id
FROM tm_tasks t
INNER JOIN vps_op_tasks vopt ON (vopt.task_id = t.task_id)
INNER JOIN vps_operations vop ON (vop.op_id = vopt.op_id)
INNER JOIN ves ON (vop.vps_host_id = ves.ve_host_id)
WHERE t.status = 'f'
AND t.name like '%Backup VPS%'
AND ves.hw_host_id = HW_NODE_ID
Replace HW_NODE_ID with the actual ID of a PVC server registered in POA, it is displayed in POA Provider Control Panel at Service Director > Virtuozzo Manager > VPS Hardware Nodes.