We can see all connected users under the User Explorer but is there a way to list out in our Wordpress system which users have connected their social accounts and with which email addresses? We can query our MySQL database with the User Token but we don't want to do it one by one.
The database is the only way to do it unfortunately.
There is registration column which identifies users with a Social Login link, but you cannot query on it.
Another way would be to add a hook at login which adds a new custom role to the Social Login users, but that will only apply after the hook is installed.