Is it possible to pull out the  success/failure reports  of MI ?
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

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

Please log in to comment

Answers

Answer this question or Comment on this question for clarity

Share