Query Adobe Flash GUID

This SCCM Query will return computers in a specified collection that have Adobe Flash Active X  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 Flash Query

Adobe Flash 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 flash%”

Sponsors