Office 2016 End of Support

[bassic]

Hi Everyone

As you may or may not know, Microsoft is ending support for Office 2016 for Mac on October the 13th 2020 (see link below).

At our company everyone has an Office 365 license, and all new Macs are deployed with the Office 365 version, however there are still a lot of users (we believe) that are still using Office 2016.

I would like to create a report of which machines are still running 2016, but as 2016, 2019 and Office 365 confusingly all seem to have the same version numbers, this is proving rather difficult.

My question is- does anyone have a clever way of differentiating Office 365 versions of Office from 2016 and 2019 in a search or a Smart Group?

Thanks!

https://support.microsoft.com/en-us/office/end-of-support-for-office-2016-for-mac-e944a907-bbc8-4be5-918d-a514068d0056#:~:text=Support%20for%20Office%202016%20for%20Mac%20ended%20on%20October%2013,will%20you%20lose%20any%20data.

[mschroder]

If my memory serves me well, the the volume licensed installs have a file /Library/Preferences/com.microsoft.office.licensingV2.plist, whereas the O365 installs have /Library/Preferences/com.microsoft.office.licensing.plist

An EA would be needed to get this from the Macs.

[mm2270]

@bassic Office 2016 and Office 2019 don't actually use the exact same version numbers. They were split up at a particular point that can actually be used to differentiate between the two releases.
Take a look at this thread, which goes into more detail on how you can build Smart Groups for each type.

[MrRoboto · Accepted solution]

Use the following Extension Attributes to gather info on Office Version and Office License. Then run Advanced Searches or create Smart Groups for reporting or targeting an upgrade policy.

MS Office License

MS Office Version

#!/bin/bash

wordVersion=$(defaults read "/Applications/Microsoft Word.app/Contents/Info.plist" CFBundleShortVersionString)
majorVersion=$(awk -F '.' '{print $1}' <<< "$wordVersion")
minorVersion=$(awk -F '.' '{print $2}' <<< "$wordVersion")

if [[ $majorVersion -ge "15" ]]; then
    if [[ "$majorVersion" -ge "16" ]] && [[ "$minorVersion" -ge "17" ]]; then
        echo "<result>2019</result>"
    else
        echo "<result>2016</result>"
    fi
else
    if [[ -d "/Applications/Microsoft Office 2011/" ]]; then
        echo "<result>2011</result>"
    else
        echo "<result>Not Installed</result>"
    fi
fi

exit 0