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)
Please log in to answer
Posted by:
akmagnum
6 years ago
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 6 years ago
