/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


MANAGED install success report

03/02/2016 724 views
Is it possible to pull out the  success/failure reports  of MI ?
Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0
This report will display any computers with a failed managed install:
SELECT MI_ATTEMPT.ATTEMPT_COUNT, MACHINE.NAME as "Computer", SOFTWARE.DISPLAY_NAME as "Software"
FROM ORG1.MI_ATTEMPT
JOIN MACHINE on MACHINE.ID = MI_ATTEMPT.MACHINE_ID
JOIN MI on MI.ID = MI_ATTEMPT.MI_ID
JOIN SOFTWARE on SOFTWARE.ID = MI.SOFTWARE_ID
WHERE MI.MAX_ATTEMPT_COUNT = MI_ATTEMPT.ATTEMPT_COUNT
This report will show the attempt count for machines targeted by a specific MI:
SELECT SOFTWARE.DISPLAY_NAME, MI.NOTES, MI_ATTEMPT.ATTEMPT_COUNT, MACHINE.NAME
FROM MI
JOIN MI_LABEL_JT on MI_LABEL_JT.MI_ID = MI.ID
JOIN MI_ATTEMPT on MI_ATTEMPT.MI_ID = MI.ID
JOIN MACHINE on MACHINE.ID = MI_ATTEMPT.MACHINE_ID
JOIN SOFTWARE ON SOFTWARE.ID = MI.SOFTWARE_ID
WHERE MI.ID = 349
You can make an assumption that if the attempt count is equal to the maximum attempts that it failed (this is the assumption made in the first report), but that isn't a guarantee. In order to distinguish between successes and failures you would also need to look at the MACHINE_SOFTWARE_JT to see if the software is installed on each computer.

Answered 03/02/2016 by: chucksteel
Red 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

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