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.
select distinct SMS_R_System.Name, SMS_R_System.ClientVersion 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 SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Shoretel Communicator" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version <= "17.60.9211.0" order by SMS_R_System.Name, SMS_R_System.ClientVersion
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:
If you have any problems with any of the above, then please leave your comments and questions below using our comments system and we will try to get back to you as soon as we can.
We also like to hear back any success stories too, so if you have used our guide and found it helpful, we would love to hear from you.
Enter your email address below and click the Subscribe button to receive email notifications about new and exciting downloads available through our website at https://www.techygeekshome.com
You will also receive notifications about new technical guides, latest news and MSI installer downloads that are available through our blog here at https://blog.techygeekshome.info
We will not spam you and we will not pass on any of your details to anyone else. We tend to post new content once or twice a week.
You can unsubscribe any time you like.