/build/static/layout/Breadcrumb_cap_w.png

Software Question


Anyone created a report that captures the "installed Programs" list from the Device view?

05/22/2018 511 views
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.

Don't be a Stranger!

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

Sign up! or login

View more:

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