Reporting on software distribution
I'm looking for a report on the current state of my software distributions. Something like:
Software | Targetted | Installed | Pending | Failed |
Adobe Reader | 25 | 12 | 7 | 4 |
Java Runtime | 25 | 15 | 3 | 7 |
Thanks.
2 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
http://www.itninja.com/blog/view/k1000-reports-tracking-managed-installs
The question is more difficult to answer than you may initially think due to the way things are tracked in the database.
Getting the targetted machines involves going through multiple labels, those which are added to each managed install and a hidden label. When individual machines are added to a MI they get assigned a hidden label for that MI.
Tracking installed would need to be a subtraction of targetted - pending - failed, since the database doesn't actually track once an MI succeeds, except by looking at the installed software table.
The MI_ATTEMPTS table tracks the number of attempts and while the number of attempts is less than or equal to the number of times the MI should try it will be in that table, but not until the first attempt is made. Because of this, the Pending number needs to include both those that have had at least one attempt (but haven't yet failed) and those that haven't had any attempts, yet. - chucksteel 9 years ago