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.
0 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
SMal.tmcc
5 years ago
Posted by:
maxiakra
2 years ago
The problem with the 'Devices' field is that they are in one field and I find it super hard to either use VLOOKUP on them, since it can't go through those many records in one field, or to split those devices into separate fields.
I think best approach is SQL in this case if you want to have a proper report.
