/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


K2000 - Automated Deployments report

06/23/2017 766 views
Hello,

I'm trying to make an sql request to monitor automated deployments (it's the begining) :

SELECT IM_NODE.IP,
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

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"?



0 Comments   [ + ] Show comments

Comments


Be the first to answer this question

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ