Ankit Sudhera Portfolio Website
You can do it without using plugin with the following SQL query to fetch and show the records. But please create a page separately.
"
SELECT user_id, wp_users.user_login, FROM_UNIXTIME(substring_index(substring_index(meta_value, '"login";i:', -1), ';}}', 1)) as last_login FROM wp_usermeta inner join wp_users on user_id = wp_users.ID WHERE meta_key='session_tokens' ORDER BY `last_login` DESC
"
You can replace the table name wp with your table name prefix.
If you have any questions, please comments or contact us.
More details with following:
"
SELECT u.ID, u.user_login, u.user_email, u.user_registered, u.display_name, FROM_UNIXTIME(SUBSTRING_INDEX(SUBSTRING_INDEX(m.meta_value,'\"login\";i:',-1),';}}',1)) AS last_login, FROM_UNIXTIME(SUBSTRING_INDEX(SUBSTRING_INDEX(m.meta_value,'\"expiration\";i:',-1),';',1)) AS logout_time FROM wp_users u LEFT JOIN wp_usermeta m ON u.ID=m.user_id AND m.meta_key='session_tokens' ORDER BY last_login DESC
"
