We can use "Manage Subscription" and also analytics UI to get this detail.
The thing is what I'm looking for is the distinct usernames. In the "Manage Subscription" tab, as well as in the 'All Subscriptions' tab under the Analytics it shows all the subscriptions including multiple subscriptions to different applications by the same user. When there are thousands of such subscriptions, finding distinct users of all the apps is tedious. I can, however, do this with the following SQL in the DB. select distinct CREATED_BY from AM_SUBSCRIPTION; I'm looking at this option for a non-technical user. On Tue, Jun 26, 2018 at 4:47 PM Rajith Roshan <[email protected]> wrote: > Hi, > Is it possible to use the manage subscription UI of the publisher, which > gives the user name > > [image: Manage-subscriptions.png] > > > On Tue, Jun 26, 2018 at 2:22 PM Shazni Nazeer <[email protected]> wrote: > >> >> Is there a way to determine the user ids of distinct current subscribers >> across all applications in the API-M from the UI? >> >> I can get the detail from the database using a query. >> >> I can also get the details of all subscriptions as well as API wise >> subscribers from the analytics. >> >> -- >> Shazni Nazeer >> >> Mob : +94 777737331 >> LinkedIn : http://lk.linkedin.com/in/shazninazeer >> >> Blogs : >> >> https://medium.com/@mshazninazeer >> http://shazninazeer.blogspot.com >> >> <http://wso2.com/signature> >> >> >> -- >> Shazni Nazeer >> >> Mob : +94 777737331 >> LinkedIn : http://lk.linkedin.com/in/shazninazeer >> >> Blogs : >> >> https://medium.com/@mshazninazeer >> http://shazninazeer.blogspot.com >> >> <http://wso2.com/signature> >> > > > -- > Rajith Roshan > Senior Software Engineer, WSO2 Inc. > Mobile: +94-717-064-214 > -- Shazni Nazeer Mob : +94 777737331 LinkedIn : http://lk.linkedin.com/in/shazninazeer Blogs : https://medium.com/@mshazninazeer http://shazninazeer.blogspot.com <http://wso2.com/signature>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
