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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...