/build/static/layout/Breadcrumb_cap_w.png

generate listing of all mac computer's software

It would be great to know if there is a way to generate some sort of listing of all Mac computers in our inventory which shows which software is installed on each machine. Also, if we could view all software and see which machines have it. Thanks.

0 Comments   [ + ] Show comments

Answers (1)

Posted by: airwolf 11 years ago
Red Belt
0
Here is a simple report to show all Mac systems and all installed software. Make sure you "break on" the NAME column when you create the report - this will group the software under each machine.


SELECT M.NAME, S.DISPLAY_NAME FROM MACHINE M
JOIN MACHINE_SOFTWARE_JT MSJT ON (M.ID = MSJT.MACHINE_ID)
JOIN SOFTWARE S ON (MSJT.SOFTWARE_ID = S.ID)
WHERE M.OS_NAME like '%Mac%'
ORDER BY 1 asc, 2 asc
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

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

Sign up! or login

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