Create a software label report
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
Answers (1)
Please log in to answer
Posted by:
dugullett
12 years ago
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
