Skip to content

Instantly share code, notes, and snippets.

@krschmidt

krschmidt/convertusers.sql

Created October 10, 2015 18:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save krschmidt/c09756eed306cb4f170a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save krschmidt/c09756eed306cb4f170a to your computer and use it in GitHub Desktop.
Download ZIP
LDAP to CAS Converstion
Raw
convertusers.sql
INSERT INTO cas_user (uid, cas_name)
SELECT u.uid AS uid, u.name as cas_name
FROM users u
WHERE uid <> 0 AND
NOT EXISTS (SELECT cas_name FROM cas_user c WHERE c.cas_name = u.name) AND
u.name NOT LIKE "L0%";
@krschmidt
Copy link
Copy Markdown
Author

krschmidt commented Oct 10, 2015

Duplicate of https://www.drupal.org/node/1261232

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment