I've been tasked with creating a report that will be similar to the PC Licensing report, for Mac software. Even better, we'd like results from both platforms tallied if possible.
On the PC side, Adobe Creative Suite is shown as Adobe Creative Suite. On the Mac, it's shown as components - PhotoShop, InDesign, Illustrator, etc.
Is there a way to filter things so that if a Mac has PhotoShop, Illustrator, InDesign, Bridge, and Acrobat, it has Creative Suite Design Standard; if it also has Premiere, it has Production Premium; if it has Dreamweaver then it has Design Web...? I'm learning SQL as I go, and this bit is beyond me.
Thanks in advance for any assistance.