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