/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


How to get Deploy Status Error Codes on Report?

04/17/2019 1044 views

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

Comments


All Answers

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

Answered 01/07/2020 by: RD94
Senior Yellow Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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