Sccm Query For Software Installed For Pc

SCCM custom query for application installed with specific version number; SCCM custom query for application installed with specific version number. Good Afternoon, I need a custom query in SCCM to target a specific software with a specific software version, so we might be able to run a mandatory assigment to uninstall this software. 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.

Sccm Wmi Query For Installed Software

So I do a lot of collection queries based on Installed Applicaion and Installed Software. Some are one, some are the other because I don't really understand the difference. I recently attended the MMS conference and /u/jasonsandys mentioned that SWI should really not be used. I guess I then have a couple questions:

Can I still query based on installed applications/version without using software inventory? What is the difference between Applications and Software in the SCCM world?

Thanks to any who reply.

Sccm Query For Software Installed Windows 10