create report of "machines with software installed". (license report)
Right now I have to go into each asset detail and copy paste the bottom table ("Machines with Software Installed") into excel. Before with only one or two titles, it wasnt a big deal. Now my list is growing and every time my boss wants a report of who has what to charge out costs I spend too much time doing manual reports.
How can we create a report that will dump that table directly into a spreadsheet? Im getting tired of the copy/pasta two step.
Ideally, and this may be asking too much, but to be able to create a XLS file with a tab for each asset would be awesome.
Ideas?
Answers (1)
You can do this as a software report in the Reporting module. There are a few delivered examples to get you started. Here is one I have for Adobe Creative Suite products:
select MACHINE.NAME as MACHINE_NAME,
IP,
MAC,
SOFTWARE.DISPLAY_NAME as SOFTWARE_NAME,
SOFTWARE.DISPLAY_VERSION AS SOFTWARE_VERSION
from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE)
where
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and
MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
and ( SOFTWARE.DISPLAY_NAME like 'Adobe Creative Suite%'
or SOFTWARE.DISPLAY_NAME like 'Adobe% CS%'
or SOFTWARE.DISPLAY_NAME like 'Adobe% Elements%'
)
order by SOFTWARE.DISPLAY_NAME, MACHINE.NAME
I hope this gets you started.
