Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
Hi all,

I have conceded and am looking for help. I have knowledge of SQL but cannot make this work.

Within my environment we have :

old machines only using Office 2010,
new machines using Office 2016 AND 2010.

I need to locate the machines that ONLY have Office 2010 on them, and do not have 2016.

I know that there is a "WHERE NOT" that I need to use somewhere, but it has been 3 days and I cannot make anything work.

Any help would be appreciated.

Thank you
Honored Sweeper II
Take a look at this and see if it's enough to get you going.