Ektron SQL – List All Users

If you’re looking for more specific access lists look at Ektron – User Access List

SELECT user_id
	,[user_name]
	,[first_name]
	,[last_name]
	,[email_address1]
	,[email_address2]
	,[email_address3]
	,[address]
	,[latitude]
	,[longitude]
FROM [users] u
ORDER BY u.user_id

SELECT utgt.usergroup_id,
	ug.usergroup_name,
	utgt.user_id,
	[user_name],
	[first_name],
	[last_name],
	[email_address1],
	[email_address2],
	[email_address3],
	[address],
	[latitude],
	[longitude]
FROM [user_to_group_tbl] utgt
INNER JOIN [usergroups] ug ON ug.usergroup_id = utgt.usergroup_id
INNER JOIN [users] u ON u.user_id = utgt.user_id
ORDER BY ug.usergroup_name