Sccm Query For Software Installed

Posted on

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. Sep 20, 2017  SCCM SQL Query for Microsoft Office 32 Bit and 64 Bit,SQL Query for Microsoft Office,SQL Query for Microsoft Office 32 bit and 64 bit. 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. How To Deploy Software. Feb 20, 2014  3 thoughts on “ How to create a collection of computers by installed software. Jmulwani July 23, 2016 at 11:13 am. Can you explain how Installed Application differs from Installled Software? There are certain applications that do not show up when we query using Installed Application even though they are visible in the add and remove programs.

A question that I see a lot is how can you create a device collection of machines that don't have a particular piece of software installed?

This task is much easier in Configuration Manager 2012 since we can make use of the include and exclude collection rules. In Configuration Manager 2007, you would need to create a sub-select query to accomplish this which takes more time.

Sccm Query For Software Installed For Pc

In this post, I'm going to demonstrate how you can use include and exclude collection rules to create a collection of machines that do and do not have a certain application installed.

Step 1: You will need to create a collection of machines that actually have the software installed. In this example, I will use Adobe Reader as my application. Here's what the query will look like in the Criterion Properties. Notice my query is finding where the Display Name contains %Adobe Reader% so it will find computers with any version of Adobe Reader installed. You could customize your query to be more specific if needed.

Here is the actual WQL you can use:

select

*

from

SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId

where Apk minecraft for pc free.

SoftwareSccm query for software installed download

SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like '%Adobe Reader%'

I have one computer in my lab that has Adobe Reader installed.

Software Development Jobs Software development engineers design and develop information systems. They study new techniques and stay up to date on all systems and licenses. Most will analyze information and have the capability to produce a solution to any issues or problems within software. Software development jobs. Welcome to the Software Development remote, part-time, freelance, and flexible jobs page! As software continues to play bigger role in the day-to-day lives of individuals and companies, software development jobs will be in high demand. 337,935 Software Development jobs available on Indeed.com. Apply to Entry Level Software Engineer, Software Engineer, Player Development Staff and more! 112,084 Software Developer jobs available on Indeed.com. Apply to Entry Level Software Engineer, Software Engineer, Application Developer and more! Skip to Job Postings. Have you recently begun your software development career and are eager to gain more experience? Search Software developer jobs. Get the right Software developer job with company ratings & salaries. 84,535 open jobs for Software developer.

Sccm 2012 Query Software Installed

Step 2: We will create a machine collection of computers that do not have Adobe Reader Installed. We will use an include and exclude rule to accomplish this.

Sccm 2012 Query For Software Installed

Add an Include Rule in the new collection wizard. You can include any collection of machines you want except the collection you created in step 1. In my case, the collection i created in step 1 was named 'Adobe Reader Installed'. I created an include rule for 'All Desktops and Servers' collection this will allow me to find all computers in my environment that don't have Adobe Reader installed.

Next we will create an exclude rule. You will exclude the collection of machines you created in Step 1. In my case, this collection was the 'Adobe Reader Installed Collection'

Exclude rules will take priority over an Include rules. For example, lets say the collection you selected for your include rule contains a computer named 'PC1' and the collection you selected for your exclude rule also contains 'PC1. In this case, PC1 will be excluded from your collection since PC1 was in the collection in your exclude rule.

Sccm Query All Software Installed On All Computers

I had 4 computers in my environment without Adobe Reader installed