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

Please log in to comment

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
Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share