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.
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 10 years ago
Answers (3)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
10 years ago
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 10 years ago
Posted by:
dugullett
10 years ago
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 10 years ago
Posted by:
mckarto
8 years ago
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.
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