This post contains the SCCM SQL query for Microsoft office 32 bit and 64 bit. Many organizations today use Microsoft office to simply the work. Listing out office versions installed on all machines is a big task. Using SQL queries it’s very easy to find out the Office versions. However note that these are the SQL queries and not the WQL queries. Here is a forum thread that lists the difference between SQL and WQL queries.

SCCM SQL Query for Microsoft Office 32 Bit and 64 Bit

The below query lists the 32 bit versions of office installed on machines.

The below query lists the 64 bit versions of office installed on machines.

If you are looking for a query that lists both 32 bit and 64 bit versions of Microsoft office installed, here it is. The query also fetches and displays the installed date as well.

 

3 COMMENTS

  1. Hi Prajwal,

    This query seems to be not working for me and i got below error.

    “This query has a syntax error. Are you sure you want to save it”

    Please help me i am new to SCCM.

    Thanks
    asad

    • Hello Asad, I have also tried this query and didn’t work for me. I am using this one now and it’s working.

      This will list 64bit of any Office ver installed.

      select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like “%Microsoft Office Professional Plus%”

LEAVE A REPLY

Please enter your comment!
Please enter your name here