Miscellaneous Question

Kace Reporting - generate an "installed applications list" for group of machines

10/06/2016 4997 views
So, my SQL-Fu is weak when it comes to this kind of thing. I can "sorta" get what I want out of the wizard, but it's way to cumbersome and requires a significant amount of post-work in excel to be functional.

What I'd like to do is generate a list of installed software from all the PCs at a particular division we have. All the PC's there utilize the same naming convention (SiteID_SerialNumber) so they are easy to differentiate from the other 1200 or so devices we have in Kace. Something like "the following 70 applications are currently installed on Division X computers" without necessarily having to drill down to individual devices.

Currently, what I get is a report that shows all the installed apps that each PC has, under each PC's line on the report. This leads to hundreds of duplicate entries (example, every PC has Adobe reader, so that's 80 entries for reader, one for each PC. you get the idea)

Any way to do this through the software catalog or software inventory lists? Like an advanced search for software on Device name - Begins with - SiteID_?
0 Comments   [ + ] Show comments


Community Chosen Answer


First of all create a label for all the machines in that site.


Create new report wizard

- choose device

- From device identity information sublist ...... choose "label names".

- From software sublist......choose "software titles"


"Column order" your choice


"Sort breaks"

Check label name, so it sorts by only the label.


Choose "specify rules to filter records"


Put in your label name and save.

Run the report

Answered 10/07/2016 by: akmagnum
Red Belt

All Answers

This content is currently hidden from public view.
Reason: Removed by member request 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


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