Software Deployment

Here are some reports that will help:
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

So... bad database design = not possible (without the Manhattan Project level of effort). *sigh* I'm surprised that not many people ask for reports like this. I come from an SCCM world and it seems like this is exactly the kind of information you get a software management system for. - Keith_75002 9 years ago