Jump to content

quick way to list members who...


Go to solution Solved by CoffeeCake,

Recommended Posts

Posted (edited)

Was just wondering how many members make use of the google, apple etc etc login feature

is there a way in acp to list all or if not is there a way to list via a mysql query ?

anyone help?

 

Edited by sound
  • Solution
Posted (edited)

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
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...