Skip to content

Instantly share code, notes, and snippets.

@alanmackenzie

alanmackenzie/drupal-user-support-query.sql

Last active August 29, 2015 14:05
Show Gist options
  • Save alanmackenzie/ee8d7259ca3481a9cc18 to your computer and use it in GitHub Desktop.
Save alanmackenzie/ee8d7259ca3481a9cc18 to your computer and use it in GitHub Desktop.
Download ZIP
Editorial friendly user support SQL query for the standard Drupal 7 database schema.
Raw
drupal-user-support-query.sql
SELECT
uid,
name,
mail,
FROM_UNIXTIME(created) AS 'account created',
FROM_UNIXTIME(access) AS 'last access',
FROM_UNIXTIME(login) AS 'last login'
FROM users
WHERE mail = 'example@example.com'\G
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment