/build/static/layout/Breadcrumb_cap_w.png
09/12/2018 205 views
Hi,

I'm in need of help, how can i extract a report of my inventory  showing all installed softwares by computers?


Thanks!
1 Comment   [ + ] Show comment

Comments

  • Do you really want a report of all software installed on each computer? What is the purpose of the report?

All Answers

0

Found this script, it doesn't bring every device but it's enough.

Select CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) as MACHINE_NAME, DISPLAY_NAME, DISPLAY_VERSION, PUBLISHER from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE) 
where
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and
SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
and not IS_PATCH
order by MACHINE_NAME, DISPLAY_NAME




if anyone knows one more complete please post it.

Answered 09/12/2018 by: paulo.roberto
White Belt