Office Smart Group

[rkovelman]

I would search for this but not sure what keywords to search for.

Anywho I need to create a smart group, two to be exact, one that shows who has Office 2011 and who has Office 2012. I tried a few ways and the results are not correct. Has anyone set this up that can share what they did in doing this?

[baldiesrt]

For us, we have the following for criteria for Office 2016
Application title HAS Microsoft Outlook.app
AND
Application version LIKE 15

[rderewianko]

Hello,
First what i'd do is pick a office app everyone's guaranteed to have (like word)
So i'd setup my smart group as follows

Computers with Microsoft Office 2011
Application title is "Microsoft Word.app"
and
Application Version LIKE 14

Computers with Microsoft Office 2016
Application title is "Microsoft Word.app"
and
Application Version LIKE 15

You could further do a search for a few apps to reduce false positives if you'd like.

Computers with Microsoft Office 2011
(Application title is "Microsoft Word.app"
or
Application title is "Microsoft Excel.app")
and
Application Version LIKE 14

Computers with Microsoft Office 2016
(Application title is "Microsoft Word.app"
or
Application title is "Microsoft Excel.app")
and
Application Version LIKE 15

The important fact to know is Office 2011 has a version of 14.x and Office 2016 has a version of 15.x

[rkovelman]

Please ignore I was able to figure it out