Kace Specific PC's software report
i want to run a report listing all installed software on a single computer. can anyone offer a solution , i see a standard report in KACE but that lists the software on each computer in the network.
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
aragorn.2003
9 years ago
Does this helps: http://www.itninja.com/question/i-am-looking-for-sql-script-for-k1000-report
Posted by:
chucksteel
9 years ago
SELECT DISPLAY_NAME, DISPLAY_VERSION FROM ORG1.SOFTWARE
JOIN MACHINE_SOFTWARE_JT on MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
JOIN MACHINE on MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
WHERE MACHINE.NAME = "machinename"
ORDER BY DISPLAY_NAME
