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.
Answer Summary:
Cancel
1 Comment   [ + ] Show Comment

Comments

  • 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.
  • This content is currently hidden from public view.
    Reason: Member has been banned from the site
    For more information, visit our FAQ's.
  • This content is currently hidden from public view.
    Reason: Member has been banned from the site
    For more information, visit our FAQ's.
  • This content is currently hidden from public view.
    Reason: Member has been banned from the site
    For more information, visit our FAQ's.
  • This content is currently hidden from public view.
    Reason: Member has been banned from the site
    For more information, visit our FAQ's.
Please log in to comment

Answers

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.
Answered 08/25/2014 by: chucksteel
Red Belt

  • Thanks, that seems to do the trick!
Please log in to comment
1
Take a look at this post.

http://www.itninja.com/blog/view/k1000-reports-tracking-managed-installs 
Answered 08/25/2014 by: dugullett
Red Belt

  • Ah, good to know - I'll check that out if I need to do more with this later!
Please log in to comment
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.
Answered 02/11/2016 by: mckarto
White Belt

  • 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.
Please log in to comment
Answer this question or Comment on this question for clarity