SCCM SQL Query for Microsoft Office 32 Bit and 64 Bit

1645

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.

 

  • asad ulla

    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