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

Comments

Please log in to comment

Answers

2
if you go to that machine details and expand that you will get details under software installed programs
Answered 07/11/2016 by: SMal.tmcc
Red Belt

  • 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
Please log in to comment
2
> "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

Answered 07/11/2016 by: JasonEgg
Third Degree Green Belt

  • 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
    • This content is currently hidden from public view.
      Reason: Junk
      For more information, visit our FAQ's.
Please log in to comment
Answer this question or Comment on this question for clarity