This would be a useful report, but the only thing I've seen on community that gets close is an outdated 8.8 Report Designer Walkthrough.
Needless to say, it does not work.
While we have not found a greta way of doing this, we have found that using the Web Console it is easier than the thick console as the web console allows you to add a "count"
we then export the results to a spreadsheet and then clean it up there.
Attached is a screenshot of how to build your query. Note, if you are logged into your system and you use different credentials to log into LANDesk you must launch IE using the Run as different user command and use the credentials you use for LANDesk.
You can use the web console by going to https://your_core_name/remote
The first time will be slow to launch.
Thanks for your response and sorry for not able to reply sooner.
Our query is created with the web cosole and it is pretty much like the one mrspike shows on the screenshot. It returns thousands of applicatoins on the output. We export the output to a spreadsheet and manually remove the dupliates and information we don't need just like mrspike mention in his post. We have not been able to figure out anything better.