How do I get a report of failed K1000 agent installs ?
Hi, how do I generate a report on failed agent installs and if possible, reason they failed ? I don't see anything baked into appliance and copy-paste doesn't work the greatest if you have a large number to devices or multiple pages.
Community Chosen Answer
The following query will give you a listing by provision config just like the detail pages of the provisioning page. Please not that the query is ignoring errors for ports not accessible as this is normally a sign of nothing being on the other end.
Select PC.NAME AS PROVISION_NAME, PN.MODIFIED AS LAST_ATTEMPT, HOST_NAME AS FAILED_HOST, FAILURE_TYPE, ERROR, TIPS
from PROVISION_CONFIG PC
INNER JOIN PROVISION_NODE PN on
PC.ID = PN.PROVISION_CONFIG_ID
INNER JOIN KBSYS.PROVISIONING_ERRORS PE on
PE.ERROR_CODE = PN.ERROR_CODE AND
ERROR != 'TCP ports not accessible';