K2000 - Automated Deployments report
Hello,
I'm trying to make an sql request to monitor automated deployments (it's the begining) :
I'm trying to make an sql request to monitor automated deployments (it's the begining) :
SELECT IM_NODE.IP,But I don't find any table where I can get more information about IM_BOOT_ACTION_RUN_ID or any link with https://k2000/action_detail?BOOT_ACTION_ID=XXX. Is there some tables unavailable for the user "report"?
IM_SYSTEM_IMAGE.NAME,
DEPLOY_STARTED,
IM_BOOT_ACTION_RUN_ID
FROM IM_LOG_IMAGE_DEPLOY
LEFT JOIN IM_SYSTEM_IMAGE ON IM_LOG_IMAGE_DEPLOY.IM_SYSTEM_IMAGE_ID = IM_SYSTEM_IMAGE.ID
LEFT JOIN IM_NODE ON IM_LOG_IMAGE_DEPLOY.IM_NODE_ID = IM_NODE.ID
ORDER BY DEPLOY_STARTED DESC
0 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question