/build/static/layout/Breadcrumb_cap_w.png

Miscellaneous Question


How can I get a report showing installed software on only one PC

07/11/2016 774 views

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


All 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
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
Red 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.

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