/build/static/layout/Breadcrumb_cap_w.png

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.


1 Comment   [ + ] Show comment
  • This is about KACE reports, correct? - dedenker 10 years ago

Answers (1)

Posted by: chucksteel 10 years ago
Red Belt
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

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