Software count with a specific department grouped by Site
I need a report to show the information below. If Acquisition and Expiration date cannot be shown that is fine for now. Our customer is really focused on number of license purchased and how many of the licenses are being used and how that relates to how many workstations the software is installed on.
| Software Manufacturer | Software Name | Department | # of times installed | # of licenses purchased | # of licenses allocated | Acquisition Date | Expiration Date |
| Site 1 | |||||||
| Adobe | Acrobat Pro | ARMY | 48 | 21 | 18 | 2/12/2012 | 2/12/2013 |
| Site 2 | |||||||
| Adobe | Acrobat Pro | Army | 35 | 18 | 18 | 2/12/2012 | 2/12/2013 |
Thank you for your help