56,687
社区成员
发帖
与我相关
我的任务
分享
CREATE
VIEW `view_execution_details` AS SELECT
(eh.ID+""+d.DEVICE_ID) as id,
detail.GRID_DATA ,
d.IP_ADDRESS ,
eh.JOB_NAME ,
eh.JOB_GROUP ,
eh.JOB_TYPE ,
eh.JOB_CLASS ,
detail.START_TIME ,
detail.END_TIME ,
eh.EXECUTOR ,
eh.STATUS ,
detail.ID as detail_id,
detail.EXECUTION_ID ,
detail.ERROR ,
detail.DETAILS
FROM
execution_history eh ,
device d ,
backup_details detail
WHERE
eh.id = detail.EXECUTION_ID
AND d.device_id = detail.device_id
UNION ALL
SELECT
(eh.ID+""+d.DEVICE_ID) as id,
detail.GRID_DATA ,
d.IP_ADDRESS ,
eh.JOB_NAME ,
eh.JOB_GROUP ,
eh.JOB_TYPE ,
eh.JOB_CLASS ,
detail.START_TIME ,
detail.END_TIME ,
eh.EXECUTOR ,
eh.STATUS ,
detail.ID as detail_id,
detail.EXECUTION_ID ,
detail.ERROR ,
detail.DETAILS
FROM
execution_history eh ,
device d ,
tool_details detail
WHERE
eh.id = detail.EXECUTION_ID
AND d.device_id = detail.device_id
UNION ALL
SELECT
(eh.ID+""+d.DEVICE_ID) as id,
detail.GRID_DATA ,
d.IP_ADDRESS ,
eh.JOB_NAME ,
eh.JOB_GROUP ,
eh.JOB_TYPE ,
eh.JOB_CLASS ,
detail.START_TIME ,
detail.END_TIME ,
eh.EXECUTOR ,
eh.STATUS ,
detail.ID as detail_id,
detail.EXECUTION_ID ,
detail.ERROR ,
detail.DETAILS
FROM
execution_history eh ,
device d ,
restore_details detail
WHERE
eh.id = detail.EXECUTION_ID
AND d.device_id = detail.device_id
UNION ALL
SELECT
(eh.ID+""+d.DEVICE_ID) as id,
detail.GRID_DATA ,
d.IP_ADDRESS ,
eh.JOB_NAME ,
eh.JOB_GROUP ,
eh.JOB_TYPE ,
eh.JOB_CLASS ,
detail.START_TIME ,
detail.END_TIME ,
eh.EXECUTOR ,
eh.STATUS ,
detail.ID as detail_id,
detail.EXECUTION_ID ,
detail.ERROR ,
detail.DETAILS
FROM
execution_history eh ,
device d ,
discovery_details detail
WHERE
eh.id = detail.EXECUTION_ID
AND d.device_id = detail.device_id