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
Fourth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity
Five Steps for Easier- and More Effective- IT Inventorying
Having an accurate inventory of all your IT assets is critical to ensuring that users are productive and that every dollar is well spent. This white paper outlines five steps that improve inventorying both hardware and software.

Share