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?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
RD94
4 years ago
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Â
FROM PATCH_MACHINE_STATUS
JOIN MACHINE ON (MACHINE.ID = PATCH_MACHINE_STATUS.MACHINE_ID)
WHERE DETECT_ERROR_CODE = 8151
