How can I get a report showing installed software on only one PC
I need a report that I can select a specific system to see what software is installed on it.
When we have a hard drive crash and have to re-install software that was on the old system but not in the image it would be very helpful to an easy way to generate a report that can I can specify the one PC name to get a list of all software installed without creating a new report. Needed so anyone in our IT office can use without much instruction.
SELECT S.ID AS 'SOFTWARE ID', S.DISPLAY_NAME, S.PUBLISHER, S.DISPLAY_VERSION
FROM SOFTWARE S JOIN MACHINE_SOFTWARE_JT MSJT on MSJT.SOFTWARE_ID = S.ID
JOIN MACHINE on MACHINE.ID = MSJT.MACHINE_ID
WHERE MACHINE.NAME = 'COMPUTER_NAME'
ORDER BY S.DISPLAY_NAME ASC