AnsweredAssumed Answered

SQL query containing 5 most used applications

Question asked by andrew1 on Jun 4, 2019
Latest reply on Jun 10, 2019 by andrew1

Hello Community

 

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. 

 

Thanks 

Outcomes