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!