Return all machines that contain one application, but not another

Comments

7 comments

  • Colby Bouma

    Due to the 1-to-many relationship between computers and applications, you have to use a Not All/Not Any Group Filter like this:

    1
    Comment actions Permalink
  • itdept

    Thanks for the quick reply....

    However, I set it up the way I see you have it, and it returned machines that contained BOTH applications, or at least the first 10 or so I checked. See below:

    1
    Comment actions Permalink
  • Colby Bouma

    Strange. This is working for me. Try switching the Not All to Not Any. Both should work, but it's worth a shot.

    1
    Comment actions Permalink
  • itdept

    Nope... went thru a few of them and they all contain both apps:

    1
    Comment actions Permalink
  • itdept

    Just created a new report from scratch just like you have, and it doesn't report ANY machines.... which I know there are some. Really strange....

    1
    Comment actions Permalink
  • Colby Bouma

    Aha! I was focusing on Collections, not Reports.

    When you have multiple tables in a Basic Report (such as Computer and Application), the Filters apply to each row of the joined data (it runs an INNER JOIN behind the scenes) instead of the entire computer.

    Just Computer: does this computer have an application named Chrome, and not any named Firefox?
    Computer and Application: does this row's Application Name match Chrome, and not match Firefox?

    If you want to have both tables in your Report, create a Collection with the same Filters and point your Report at it with Select Collection Source.

    1
    Comment actions Permalink
  • itdept

    Gotcha…. that DOES work. Thanks Colby, much appreciated!

    1
    Comment actions Permalink

Please sign in to leave a comment.