I would like to ask if you know about SQL query which I could run to see 5 most used applications. Excluding "MS Office apps". Reason for this is that we need to do this for all of our customers and as there is no option to run reports on "partner" level inside SLM. We need to do it in SQL to save save time.
Only problem which I see is that I would need to run this for each "CID". Is it possible to have one query which will run it for each "CID". Something like "foreach" and all data would be in one report.