Adobe Acrobat query in SCCM

Writing a query for your deployment in SCCM is very tedious work. In this article, I want to to give some example of Adobe queries. here’s how:

 

Adobe Reader DC
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Adobe Acrobat Reader DC" And SMS_G_System_INSTALLED_SOFTWARE.ProductVersion = "18.009.20050"

Acrobat Pro
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Adobe Acrobat%Pro%" and SMS_R_System.ResourceId not in (select SMS_G_System_INSTALLED_SOFTWARE.ResourceID FROM SMS_G_System_INSTALLED_SOFTWARE WHERE SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Adobe Acrobat%Pro%" AND SMS_G_System_INSTALLED_SOFTWARE.ProductVersion = "11.0.23")

Acrobat Std
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Adobe Acrobat%Standard%" and SMS_R_System.ResourceId not in (select SMS_G_System_INSTALLED_SOFTWARE.ResourceID FROM SMS_G_System_INSTALLED_SOFTWARE WHERE SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Adobe Acrobat%Standard" AND SMS_G_System_INSTALLED_SOFTWARE.ProductVersion >= "11.0.23")

Adobe Reader
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Adobe Reader%" and SMS_R_System.ResourceId not in (select SMS_G_System_INSTALLED_SOFTWARE.ResourceID FROM SMS_G_System_INSTALLED_SOFTWARE WHERE SMS_G_System_INSTALLED_SOFTWARE.ProductName Like "Adobe Reader%" AND SMS_G_System_INSTALLED_SOFTWARE.ProductVersion >= "11.0.23") and SMS_R_System.ResourceId not in (Select SMS_G_System_SoftwareFile.ResourceID From SMS_G_System_SoftwareFile Where SMS_G_System_SoftwareFile.FileName = "acrobat.exe")

Flash ActiveX
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client 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 Player%ActiveX%" and SMS_R_System.ResourceId in (select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Adobe Flash Player %ActiveX%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version <= "27.0.0.187")

Flash Plugin
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where (SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Adobe Flash Player % NPAPI%") and SMS_R_System.ResourceId is in (select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Adobe Flash Player % NPAPI%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version <= "27.0.0.187")

 

Add a Comment