Patch Management Group

Expand all | Collapse all

Help With Office 2019 Build Version Report

Jump to Best Answer
  • 1.  Help With Office 2019 Build Version Report

    Trusted Advisor
    Posted 12-21-2018 11:02 AM

    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.



  • 2.  RE: Help With Office 2019 Build Version Report

    Trusted Advisor
    Posted 12-21-2018 11:57 AM

    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



  • 3.  RE: Help With Office 2019 Build Version Report
    Best Answer

    Trusted Advisor
    Posted 12-21-2018 11:58 AM


  • 4.  RE: Help With Office 2019 Build Version Report

    Trusted Advisor
    Posted 12-21-2018 11:58 AM


  • 5.  RE: Help With Office 2019 Build Version Report

    Trusted Advisor
    Posted 12-21-2018 01:28 PM

    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