MANAGED install success report
Is it possible to pull out the success/failure reports of MI ?
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
8 years ago
Top Answer
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.
Comments:
-
Very nice report, Chuck. - rockhead44 8 years ago