/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: SMal.tmcc 4 years ago
Red Belt
2
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 4 years ago
Posted by: JasonEgg 4 years ago
Red Belt
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


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 4 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ