Jump to content


Query Installed Software By Indentifying Number

Recommended Posts

Hello All,


I've been using a PowerShell module to locate installed software on PCs. This post explains what I'm doing:




This allows me to obtain the unique identifying number of installed software. I'll use Adobe Acrobat XI Standard as an example. Here is the identifying number for Adobe Acrobat XI Standard:




I'm curious if it is possible to then write a WQL query in SCCM 2012 R2 CU4 that would query all PCs for installed software using that number listed above. If so, I would appreciate any help!


Thank you!

Share this post

Link to post
Share on other sites

i believe the reference ID is nothing bu the product ID of the application.

You can try below WQL collection to get the clients with specific Product ID:


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 inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.ProdID = "{00411F26-C366-49CF-950F-D86674E24D90}" and SMS_G_System_ADD_REMOVE_PROGRAMS_64.ProdID = "{00411F26-C366-49CF-950F-D86674E24D90}"

Share this post

Link to post
Share on other sites




I try to query the collection's Windows 7 clients where Citrix 3.2.0 "{8EC50898-E24A-4C0C-A1F2-A71A8DBF291F}" is not installed.

I have limited my collection to the All System Windows 7 collection & defined the WQL query following :


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.ProdID != "{8EC50898-E24A-4C0C-A1F2-A71A8DBF291F}"


But it doesn't work.



Please, help me

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.

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.


  • Create New...