/build/static/layout/Breadcrumb_cap_w.png

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

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

Answers (1)

Posted by: akmagnum 5 years ago
Red Belt
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


Comments:
  • It is better than what I was producing via the wizard! Thanks. - ACaiazzo 5 years ago

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