Jump to content

Community

quick way to list members who...


sound
 Share

Go to solution Solved by CoffeeCake,

Recommended Posts

  • Solution

I don't believe this is accessible in the ACP, yet after making backups of your backups and running this entirely at your own risk, you could use something like the following SQL query to return the results you're looking for:

SELECT
     substring_index(clm.`login_classname`,'\\', -1) AS LoginMethod
    ,count(1) AS NumberOfMembersLinked
FROM
    `core_login_links` cll
INNER JOIN
    `core_login_methods` clm
         ON clm.`login_id` = cll.`token_login_method`
WHERE
	cll.`token_linked` = 1 /* Only those who have successfully linked */
GROUP BY
     substring_index(clm.`login_classname`,'\\', -1)

 

Edited by Paul E.
Only show those who have successfully linked
Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy