→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
alexander_cain
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
1 REPLY 1
RCorbeil
Honored Sweeper II
Take a look at this and see if it's enough to get you going.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now