/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: RD94 1 year ago
Senior Yellow Belt
0

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

 
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