report MI failed
Can anyone tell me how to create a report to list all Mi failed on device ?
I can't do it whitch assist report.
I can't do it whitch assist report.
1 Comment
[ + ] Show comment
-
This is about KACE reports, correct? - dedenker 10 years ago
-
yes - lefeuvre 10 years ago
Answers (1)
Please log in to answer
Posted by:
chucksteel
10 years ago
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