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 andSOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and not IS_PATCHorder by MACHINE_NAME, DISPLAY_NAME
if anyone knows one more complete please post it.
Sign up today to participate,
stay informed, earn points and establish a reputation for yourself!