Help with report for Office 2010 machines. without Office 2016

[alexander_cain]

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

[RCorbeil]

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