/build/static/layout/Breadcrumb_cap_w.png
Got an audit coming up and seem to be having issues getting a Device: Installed Software list that doesn't include executable files, Server items and misc. stuff.  In a perfect scenario what I would like to see is the list of installed Programs with Version, Publisher and # of workstations software is installed. 
0 Comments   [ + ] Show comments

Comments


All Answers

1

This will report on all "devices and the software's installed on them...


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

Answered 05/23/2018 by: akmagnum
Red Belt

  • It is better than what I was producing via the wizard! Thanks.