/build/static/layout/Breadcrumb_cap_w.png

How to identify failed managed installs

Hi folks,

We're ramping up our use of the K1000 for software deployment, and it would be really useful to have a report of any managed installs that have failed, rather than having to check them individually. I've got an idea of how reports work generally, but I can't seem to find an appropriate limitation whether I categorize it as Managed Installations [that have failed on one or more computers] or Computers [that have a failed managed install, or even any pending ones.] Any tips would be much appreciated.

1 Comment   [ + ] Show comment
  • Ditto here... We just rolled out and it seems cumbersome trying to determine which devices still need the agent installed. We'd also like a way to periodically reconcile to make sure we don't have devices in the field that are un-patched. - rmavery 9 years ago

Answers (3)

Answer Summary:
Posted by: chucksteel 9 years ago
Red Belt
1
I was looking for a similar report and came up with this:

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

The tricky thing is KACE doesn't actually track in the database that the machine "failed" the managed install, but instead stops trying when the attempts reaches the number of times it should try, so you need to compare those two numbers in the query. Note that whenever a managed install is saved the attempts get reset for all machines.

Comments:
  • Thanks, that seems to do the trick! - zschuetz 9 years ago
Posted by: dugullett 9 years ago
Red Belt
1
Take a look at this post.

http://www.itninja.com/blog/view/k1000-reports-tracking-managed-installs 

Comments:
  • Ah, good to know - I'll check that out if I need to do more with this later! - zschuetz 9 years ago
Posted by: mckarto 8 years ago
White Belt
0
We have K1000 6.3 installed and I was looking for the failed machines. Now they are listed:
open your managed installation
scroll down to "Schedule"
just above the "Managed Installation Tasks" where it says something like
20 Total # devices should deploy to - 10 - # Devices software still to be deployed - 2 - # Devices software deployment failed
Above is in brackets [Show All] - click on that and it shows the list of installed and not installed machines.

Comments:
  • Yes, they are listed in the web interface but the original question was to create a report so you don't have to check each MI individually. - chucksteel 8 years ago

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