SCCM SQL Query for Microsoft Office 32 Bit and 64 Bit

dark_blb

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.

 

You might also like

4
Leave a Reply

2 Comment threads
2 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
newest oldest most voted
michael

yes it doesn’t work for me as well

BonesInRuncorn

Hi, if you’re copying and pasting the query directly you’ll need to delete and re-enter the speech marks before and after the % as SCCM wont recognise them as a valid character.

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

Mahmoud Abdelrahman

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%”

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. AcceptRead More