Can anyone tell me how to create a report to list all Mi failed on device ?
I can't do it whitch assist report.

1 Comment   [ + ] Show Comment

Comments

Please log in to comment

Answers

1
You have to look at the MI_ATTEMPT table to see the number of attempts. Here's a report that looks at that table and joins in some others. It returns entries where the attempts equals the maximum number set for a given managed install, which should indicate a failure:

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

Answered 07/03/2014 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity