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.
Thanks
Steve
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
SMal.tmcc
8 years ago
if you go to that machine details and expand that you will get details under software installed programs
Comments:
-
Thanks for the info but I was hoping for a report that could be saved to refer to after the same system was re-imaged and added back to KACE with the same name.
Any other ideas?
Thanks
Steve - SteveNew 8 years ago
Posted by:
JasonEgg
8 years ago
> "Needed so anyone in our IT office can use without much instruction"
If that's the goal, then SMal's advice is the best: it's easy to instruct people to search for a computer, click on the name, scroll to software, then click to expand it. The "next simplest" thing would be to have a SQL report that would need to be edited to apply to each different computer. You could also create a pre-canned report for every computer (not feasible unless you're managing under 50 computers) or have the query return all software on all machines (also not viable for a large number of devices).
That being said, here's a query:
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
Comments:
-
That was what I was afraid of. We have the query to return all software on all machines. Too much info for my needs.
I was hoping for a silver bullet that I had not found yet.
Thanks everyone for your input.
Steve - SteveNew 8 years ago
