Client Management Suite

We need to generate a report on installed Adobe Creative Suite for both Mac and Windows.  It's farily simple to get reports on individual components but I  need to inteligently agregate them into their correct packages (Standard, Premium, Master, etc.)  Does anyone know how to do this? 

Thanks for your help!

For CS5, only Standard includes Photoshop CS5, since Premium includes CS5 Extended.  Master Collection includes programs not found in Standard or Premium, such as After Effects or Contribute.

I don't have an inventory set in front of me that includes these products, but it would be something like:

SELECT vc.Name, vc.[OS Name]
FROM vComputer vc
JOIN Inv_AddRemoveProgram arp ON arp._ResourceGuid=vc.Guid
WHERE arp.DispayName='Adobe Photoshop CS5' AND vc.Guid IN (SELECT arp._ResourceGuid FROM Inv_AddRemoveProgram arp WHERE arp.DisplayName='Adobe InDesign CS5')

You could extend the AND vc.Guid IN () procedure for as many programs as you wanted to use to define whether it really was Standard.  For example, if you required each program.

If Adobe Photoshop CS5 Extended doesn't appear as 'Extended' in inventory, then you could add an AND vc.Guid NOT IN (SELECT arp._ResourceGuid FROM Inv_AddRemoveProgram arp WHERE arp.DisplayName='Dreamweaver CS5') or some other Premium-only program.

Then flip the NOT IN to IN to make this a Premium report, adding a NOT IN() for something like Contribute or After Effects.

Then add a few more AND vc.Guid IN () SELECT statements to clarify what Master Collection is.

http://en.wikipedia.org/wiki/Adobe_Creative_Suite#Creative_Suite_5
http://en.wikipedia.org/wiki/Adobe_Creative_Suite#Editions (for CS6)

Does this help?

Thanks Mike,

This does help for Windows workstation but, unfortunately, not for Macs which represent about 30% of our fleet and probably more of our Adobe instances.  Please correct me if I am wrong!

Charles Rubin

Arethe Apple products inventory stored in a different table?

Inv_AddRemovePrograms is Windows only.  To get installed software for every OS, use Inv_InstalledSoftware.  Something like this:

SELECT ci.Name, sci.Name, i.InstallDate
FROM vRM_Software_Component_Item sci
JOIN Inv_InstalledSoftware i
   ON i._SoftwareComponentGuid = sci.Guid
   AND i.InstallFlag = 1
JOIN vRM_Computer_Item ci
   ON ci.Guid = i._ResourceGuid
WHERE LOWER(sci.Name) LIKE '%creative suite%'