12 June 2012

SMS/SCCM Query for all Adobe CS3 products

This query will return a list of all systems with Adobe CS3 products. It omits the useless products such as Stock Photos, Asset Services, and such.

 select distinct SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName 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 Acrobat%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like 
"%CS3%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Creative Suite 3%") and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Anchor Service%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Linguistics%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Bridge%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName 
not like "Adobe Device Central%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe XMP Panels%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Stock Photos%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Asset Services%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Help Viewer%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Version Cue%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Default Language%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Update Manager%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe SING%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName 
not like "Adobe WAS%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Add or Remove Adobe Creative 
Suite 3%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe After Effects%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Glyphlet%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe XMP DVA Panels%" order by SMS_R_System.Name  

0 comments:

Post a Comment