Revision history of "Admin SQL queries"

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

  • curprev 09:51, 10 January 2024‎ Kpe talk contribs‎ 632 bytes +632‎ Created page with "=== Extract list of users and groups === One line for each group SELECT user.Name, user.EMAIL, user.IsActive, usergroup.Groupname, usergroup.LDAPNAME FROM user INNER JOIN usergroupmember ON usergroupmember.UserID = user.UserID INNER JOIN usergroup ON usergroupmember.GroupID = usergroup.GroupID ORDER BY 1 One line for each user SELECT user.Name, user.EMAIL, user.IsActive, GROUP_CONCAT(usergroup.Groupname) AS ListOfGroups FROM user INNER JOIN usergroupm..."
Retrieved from "https://wiki.tempusserva.dk/index.php?title=Admin_SQL_queries"