Smart Group to Determine machines that have both office 2011 and 2016

[bbot]

Does anyone have a working smart group to determine macs with both office 2011 and 2016 installed?

[mm2270]

Something like this maybe?

Application Title | has | Microsoft Outlook.app
and
Application Version | like | 14.
and
Application Title | has | Microsoft Outlook.app
and
Application Version | like | 15.

You could swap out Outlook for one of the other applications, like Word, Excel, etc. I'm not sure if using something like the Microsoft Auto Update application will work in this case, since I think there's only one and it gets updated with the new Office install.

[bbot]

The . in 14. and 15. did it for me. I was trying the exact with just 14 and 15 and my report was skewed... probably due to the fact that the version numbers contain so many digits now.

[emily]

I have an extension attribute that relies on Word to check for versions and reports them. May work for what you want:
https://github.com/smashism/jamfpro-extension-attributes/blob/master/type_MSOfficeVersion.sh

[bbot]

@emily This may work too! I may use both smart group and your EA with a smart group and compare the values.