How to get Deploy Status Error Codes on Report?
We currently have a weekly patch report that I review. I want to add the error code that comes up under Deploy Status and Detect Status on the Device Detail page. It would be something like Fail (80) or Fail (27). Has anyone been able to find this column/table in the database?
Here's what I do to get my error 8151 label.
You could probably glean what you need to get as far as the detect code from it to customize your query.
SELECT DISTINCT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID
JOIN MACHINE ON (MACHINE.ID = PATCH_MACHINE_STATUS.MACHINE_ID)
WHERE DETECT_ERROR_CODE = 8151