/build/static/layout/Breadcrumb_cap_w.png

Seeking KACE Report assistance querying software versions

A project I'm working on involves investigating what versions of Adobe Reader are still in use on company devices. Through the KBOX we can easily run advanced searches to find devices with that program currently installed and what version it has, but there's no way to easily export this information (in Software Detail) so it can be cross-referenced with the information of the devices themselves that I have been able to find.  With the Report wizard's software title giving us an over-abundance of info and an inability to pull from both the MACHINE and SOFTWARE tables, we're unable to pull reports we can use through that avenue. What I need is a relatively easy way to generate a report that gives me the device name, the IP address, the last user, Adobe version, and last inventory time/date for all out-dated machines.

I'm not familiar enough with SQL to write a report blindly; is there a better way to acquire the information we're after?  If not, I may just have to break down and do it the hard way!


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: rock_star 9 years ago
4th Degree Black Belt
0
Select MACHINE.NAME as Computer_Name,SOFTWARE.DISPLAY_NAME as Application_Name,display_version,IP, REPLACE(MACHINE.USER_LOGGED,'\\','\\\\') as USER_LOGGED, LAST_SYNC from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE) where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and SOFTWARE.DISPLAY_NAME like '%Adobe Reader%' order by DISPLAY_NAME

Comments:
  • You really are a rock star! :) Ran the report and it gave me exactly what I wanted. Thank you! - arogers 9 years ago
 
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