On Wed, Jun 27, 2018 at 3:47 AM Shazni Nazeer <[email protected]> wrote:
> 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. > I don't think we have an API to get unique subscribers or from the UI. > > 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 > -- Harsha Kumara Associate Technical Lead, WSO2 Inc. Mobile: +94775505618 Blog:harshcreationz.blogspot.com
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
