Kace Report to count software versions
I'm looking to create a report that will show the number of installs for each version of Java. So the columns would be:
Software Title, Version, Count
I tried creating SQL for this report using an advanced search, but it doesn't show the device counts for each version like the advanced search did. Sadly I am not great with SQL so any help is appreciated.