Jump to content




xerxes2985

Can't get application collection working



Recommended Posts

__GENUS          : 2
__CLASS          : Win32Reg_AddRemovePrograms
__SUPERCLASS     :
__DYNASTY        : Win32Reg_AddRemovePrograms
__RELPATH        : Win32Reg_AddRemovePrograms.ProdID="{93F653D3-ED8B-4A04-BA58-3DF60B37D58B}"
__PROPERTY_COUNT : 5
__DERIVATION     : {}
__SERVER         : NAME_HIDDEN
__NAMESPACE      : root\cimv2
__PATH           : \\NAME_HIDDEN\root\cimv2:Win32Reg_AddRemovePrograms.ProdID="{93F653D3-ED8B-4A04-BA58-3DF60B37D58B}"
DisplayName      : IBM Spectrum Protect Client
InstallDate      : 20170621
ProdID           : {93F653D3-ED8B-4A04-BA58-3DF60B37D58B}
Publisher        : IBM
Version          : 08.01.0000
PSComputerName   : NAME_HIDDEN

 

OK. Here is my issue. I have created a collection that I am attempting to populate with all computers that contain the specific application listed above (IBM Spectrum Protect Client). I created the collection and a query using the criteria button, added the installed application, and chose the display name to match what is contained above. I do membership update, yet no computers appear in the collection. 

I can run a report (Companies & Products > Computers with specific software registered in Add Remove Programs) and match the same Display name, and return results.

The reason I need the collection for the specific software, is I need to install an update that is only applicable to the specific version listed. 

 

Thanks

 

Share this post


Link to post
Share on other sites


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 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "IBM 
Spectrum Protect Client" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.Version = 
"08.01.0000"


Here is the query language. 

And the Criteria that I specified which generated it.

crit.PNG.25afcde2690a0a75763f09d957e49dbe.PNG

Share this post


Link to post
Share on other sites
3 minutes ago, GarthMJ said:

This query will only find x86 version of the software. 

You will need to update the collection to gather x64 version too.

https://www.enhansoft.com/blog/combining-two-wql-queries-in-one-collection

 

You are a lifesaver. The application is only 64-bit. Thanks!! And thank you for the nice guide on conducting two queries for collections :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×