/build/static/layout/Breadcrumb_cap_w.png

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?


0 Comments   [ + ] Show comments

Answers (1)

Posted by: grayematter 10 years ago
5th Degree Black Belt
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.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ