Query Installed Software By Indentifying Number

[mcamero]

Hello All,

 

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

 

http://blogs.technet.com/b/heyscriptingguy/archive/2011/12/14/use-powershell-to-find-and-uninstall-software.aspx

 

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:

 

AC76BA86-1033-FFFF-BA7E-000000000006

 

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!

[Eswar Koneti]

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}"

[pascal]

Hello,

 

 

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