Try creating a view with this instead:
GROUP BY Publisher, Version, SuiteName
ORDER BY Publisher, SuiteName, Version
This should do what you need.
Also, you can do this in the webconsole quite easily, just write a query that finds any machine where the device name exists, and then set the output columns to the ones you want to see and add a count on the appropriate field. As long as you don't include the device name in the columns to display you will get a very similar result.
The query doesn't display well so i attached it as a text file.
Mark Star -MarXtar LANDesk Enhancements
Home of Power State Notifier & Wake-On-WAN for LANDesk
sqlview.txt 233 bytes