Query for Adobe Reader GUID

This SCCM Query will return PC’s in a specified collection that have Adobe Reader installed along with the Computer Name, Application Display Name, Product ID / GUID and Version number. The results of the SCCM Query will be similar to the image below.

Adobe Reader Query

Adobe Reader Query

select SMS_R_System.NetbiosName, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version, SMS_G_System_ADD_REMOVE_PROGRAMS.ProdID 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 like “%adobe reader%”

 

Sponsors