Finding Laptops ONLY that do NOT have LogMeIn installed

Follow

Erik Sheldon

• March 19, 2020 15:02

I'm trying to find out which laptops don't have LogMeIn installed on them.  Basic query of searching for the laptop model pulls back all the laptops, but if I put in "Application name does not LogMeIn" as well, it pulls back some with and some without LogMeIn.  What am I doing wrong?

1

• 

  Colby Bouma

  • March 19, 2020 15:09

  Applications have a one-to-many relationship with Computers, so you have to flip the logic around like this:

  

  2

  Comment actions Permalink
• 

  Erik Sheldon

  • March 19, 2020 16:34

  Thanks so much, @...!  That was it!  

  0

  Comment actions Permalink
• 

  Jon

  • May 27, 2020 14:47

  This helped me with a building a collection to find computers that DON'T have a particular local printer installed.  So, thank you!

  Just curious...is it possible to see the SQL code behind this to see what's it's actually doing?

   

  0

  Comment actions Permalink
• 

  Colby Bouma

  • May 27, 2020 16:32

  >Just curious...is it possible to see the SQL code behind this to see what's it's actually doing?

  Unfortunately, no. The code for Filter logic is far from simple and isn't something I can easily share.

  0

  Comment actions Permalink

Please sign in to leave a comment.