SCCM – WQL Query for machines with specific software installed and version or below

sql

If you need to identify machines with specific software installed on a machine but would also like to know whether they have a certain version of the stated software or below, then you can use the below query.

This can help with software upgrades to identify machines that have not yet been upgraded.



Query

You can change the where statements for the software you want to query and also the version number. In the example above, we are using Shoretel Communicator and version 17.60.9211.0, which actually translates as – return to me any machines that have Shoretel Communicator v12.3 (17.60.9211.0) or below install on them.

HOW DO I CREATE THE SSRS REPORT?

We have now created a guide that will help you to create your SSRS reports based on the data that this guide will pull into the Configuration Manager database.

You can access this guide by clicking the link below:

Create a SSRS Report using Configuration Manager Database Data

More Queries

Our full range of SQL and WQL Collection queries are available here.

Feedback

If you have any questions or feedback about this post, or if you would like us to create any queries for you, please go ahead and leave us a message below in the comments section and we will get back to you as quick as we can.



1 Response

  1. Owais says:

    Hi thanks for the query but not giving the results

Leave us a message...