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?

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

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.

Answered 04/18/2014 by: grayematter
Fifth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity