Inventory Reports with Installed Software
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
-
Do you really want a report of all software installed on each computer? What is the purpose of the report? - chucksteel 5 years ago
Answers (2)
Please log in to answer
Posted by:
JasonEgg
5 years ago
Go to "Reporting" > "Reports" then search for "Software on Computer" and run that report
WARNING: depending on the size of your environment this report might be HUGE
Posted by:
paulo.roberto
5 years ago
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.