Office Smart Group

rkovelman
New Contributor III

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?

3 REPLIES 3

baldiesrt
New Contributor

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

rderewianko
Valued Contributor II

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
New Contributor III

Please ignore I was able to figure it out