/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


SCCM custom query for application installed with specific version number

02/12/2013 55730 views

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 from our workstation fleet.

I had the following but can't get the query to get the version number correctly

So essentially what I need to target is IPFX for Outlook  with a specific version number 4.2.3

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 where SMS_R_System.Name in (select distinct SMS_R_System.Name 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 = "IPFX for Outlook")

0 Comments   [ + ] Show comments

Comments


All Answers

2

Think this is the wrong Topic for this question but...

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 where SMS_R_System.ResourceId in (select ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where ProdID = '%GUID%' and SMS_G_System_ADD_REMOVE_PROGRAMS.Version = '%VERSION%')

gl! :)

Answered 02/12/2013 by: asman
Purple Belt

  • thank you ill give that a go
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ