Hi,

I am trying to generate a report which shows how many machines have two different programs installed. I would prefer to see this information presented using a pie chart but currently struggling to generate anything meaningful.

Just wondering if anyone is able to point me in the right direction? Not sure if it helps but any machines which have these applications installed are automatically assigned to a label (smart label) which shares the same name as the application.

Thanks!

 

 

 

 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

4

This will work. Just change your software titles to match. I can't really help you much on the pie graph. Something like this might be able to help you. There is an option for different graphs. http://www.itninja.com/blog/view/custom-report-layout

SELECT M.NAME,IP, MAC

FROM MACHINE M

LEFT JOIN MACHINE_SOFTWARE_JT ON M.ID = MACHINE_SOFTWARE_JT.MACHINE_ID

LEFT JOIN SOFTWARE S ON MACHINE_SOFTWARE_JT.SOFTWARE_ID = S.ID

WHERE S.DISPLAY_NAME like '%SOFTWARE_NAME_1%' OR S.DISPLAY_NAME like '%SOFTWARE_NAME_2%'

ORDER BY M.NAME
Answered 09/06/2012 by: dugullett
Red Belt

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

Share