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!

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

  • This content is currently hidden from public view.
    Reason: Removed by member request
    For more information, visit our FAQ's.
Please log in to comment

Answers

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
Answered 03/28/2015 by: rock_star
Black Belt

  • You really are a rock star! :) Ran the report and it gave me exactly what I wanted. Thank you!
Please log in to comment
Answer this question or Comment on this question for clarity