We're about to start with the imaging of 8,000 plus machines starting in March. With 3.6 and the new task engine it's nice to be able to see which have failed. Using a 3rd party tool this will return all machines that have failed a system image in the past day.
SELECT IMS.NAME, IM.MAC, I.DEPLOY_STARTED, I.STATUS
FROM KBDB.IM_LOG_IMAGE_DEPLOY I
LEFT JOIN KBDB.IM_NODE IM ON IM.ID = I.IM_NODE_ID
LEFT JOIN KBDB.IM_SYSTEM_IMAGE IMS ON IMS.ID= I.IM_SYSTEM_IMAGE_ID
WHERE I.STATUS = 'FAILED'
AND DEPLOY_STARTED > DATE_SUB(NOW(), INTERVAL 1 DAY)
Scripted Installs (not tested. Sorry I have none to test):
SELECT IMS.NAME, IM.MAC, SI.INSTALL_STARTED, SI.STATUS
FROM KBDB.IM_LOG_SCRIPTED_INSTALLATION SI
LEFT JOIN KBDB.IM_NODE IM ON IM.ID = SI.IM_NODE_ID
LEFT JOIN KBDB.IM_SYSTEM_IMAGE IMS ON IMS.ID= SI.IM_BOOT_IMAGE_ID
WHERE SI.STATUS = 'FAILED'
AND SI.INSTALL_STARTED > DATE_SUB(NOW(), INTERVAL 1 DAY)