Patch Management Group

For now, ITMS/CMS doesn't support patching office 2019.  See this related post.

I still need a way to report on versions of office 2019 to make sure clients are updating properly (right now we're testing using Microsoft's CDN).

Could someone help me build a report that will return build version for Office 2019 installed clients only?  Our other clients are office 2013 and I'd prefer not to have them on the report if possible.

For example, this page says latest build is Version 1808 (Build 10339.20026).

In CMS, under software for a test client, it shows the version (bit different format as 16.0.10339.20026, but that's fine).

Thanks as always to the SQL experts around here.

A "Simple" SQL Report for Reporting on Microsoft Office Installed Versions
https://www.symantec.com/connect/articles/simple-sql-report-reporting-microsoft-office-installed-versions

Add Office version column to a report
https://www.symantec.com/connect/forums/add-office-version-column-report

report of ms office
https://www.symantec.com/connect/forums/report-ms-office

Thanks @alex this got me what I wanted from one of the posts linked.

SELECT

vc.Name as 'Computer'
,vc.[User]
,vc.[OS Name]
,vc.[System Type]
,iadd.DisplayName as 'Software'
,iadd.DisplayVersion as 'Version'

FROM vComputer vc

LEFT JOIN Inv_AddRemoveProgram iadd ON iadd._ResourceGuid = vc.Guid

WHERE
    vc.IsManaged = 1
    AND iadd.DisplayName LIKE 'Microsoft Office Professional Plus 2019%'
    AND iadd.InstallFlag = 1
    
ORDER BY vc.Name