I'm trying to figure out the best way to do this:

We want a report that will allow us to see a list of machine names (with associated username) that do NOT have a specific version of software installed (Outlook 2007 for example).

Its easy to pull a report of machines with Outlook 2007 and another report of all machines, but how do I display the computers that show up on the all machines report that are not on the Outlook 2007 report?

Thanks in advance!
0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


The cheater way to do it would be create a machine smart label.

Have the criteria set to software title does not contain outlook (or whatever your searching for).

Modify the select statements to return only the computer name and whatever else your looking for.

Finally use this SQL as a custom report.
Answered 04/06/2011 by: dchristian
Red Belt

Please log in to comment