Tip of the day: Queries that get you a list of machines with Adobe Creative Suite installed.
*Requires Normalize CM
Manufacturer Product Name Edition Name Major Version
Adobe Systems Creative Suite Design Premium CS5.5
Adobe Systems Creative Suite Design Standard CS5.5
Adobe Systems Creative Suite Master Collection CS5.5
Adobe Systems Creative Suite Production Premium CS5.5
Adobe Systems Creative Suite Web Premium CS5.5
Adobe Systems Creative Suite Design Premium CS5
Adobe Systems Creative Suite Design Standard CS5
Adobe Systems Creative Suite Master Collection CS5
Adobe Systems Creative Suite Production Premium CS5
Adobe Systems Creative Suite Web Premium CS5
Adobe Systems Creative Suite Design Premium CS4
Adobe Systems Creative Suite Design Standard CS4
Adobe Systems Creative Suite Master Collection CS4
Adobe Systems Creative Suite Production Premium CS4
Adobe Systems Creative Suite Web Premium CS4
Adobe Systems Creative Suite Web Standard CS4
Adobe Systems Creative Suite Design Premium CS3
Adobe Systems Creative Suite Design Standard CS3
Adobe Systems Creative Suite Master Collection CS3
Adobe Systems Creative Suite Production Premium CS3
Adobe Systems Creative Suite Standard CS3
Adobe Systems Creative Suite Web Premium CS3
Adobe Systems Creative Suite Web Standard CS3
Adobe Systems Creative Suite Design Premium CS2
Adobe Systems Creative Suite Design Standard CS2
Adobe Systems Creative Suite Premium CS2
Adobe Systems Creative Suite Standard CS2
Adobe Systems Creative Suite Master Collection CS
Adobe Systems Creative Suite Premium CS
Adobe Systems Creative Suite Standard CS
Adobe Systems Creative Suite Web Premium CS
Adobe Systems Creative Suite Web Standard CS

The Normalize CM class BDNA_SOFTWARE_DATA, contains all your inventoried software. You can query this table using the following WQL or SQL.
WQL:
select System.Name, Software.Publisher, Software.Family, Software.SoftwareName, Software.Component, Software.MinorVersion, Software.MajorVersion, Software.Edition, Software.Category1, Software.Category2 from SMS_R_System inner join SMS_G_System_BDNA_BDNASOFTWAREDATA_1_1 as Software on Software.SMSUniqueIdentifier = SMS_R_System.SMSUniqueIdentifier inner join SMS_R_System as System on System.SMSUniqueIdentifier = Software.SMSUniqueIdentifier where Software.Publisher = ”Adobe Systems” and Software.SoftwareName = ”Creative Suite”
SQL:
SELECT v_R_System.Name0 as Name, Software.Publisher0 as Publisher, Software.Family0 as Family, Software.SoftwareName0 as SoftwareName, Software.Component0 as Component, Software.MinorVersion0 as MinorVersion, Software.MajorVersion0 as MajorVersion, Software.Edition0 as Edition, Software.ServicePack0 as ServicePack, Software.Category10 as Category1, Software.Category20 as Category2
FROM v_R_System
INNER JOIN v_GS_BDNA_Software_Data0 Software ON Software.SMSUniqueIdentifier0 = v_R_System.SMS_Unique_Identifier0
WHERE Software.Publisher0 = ’Adobe Systems’ AND Software.SoftwareName0 = ’Creative Suite’