Ektron SQL – List All Users

Posted on By David Kittell

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
Originally Posted on July 19, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Ektron Ektron User Management MSSQL MSSQL - Ektron MSSQL - Ektron 8.0.2 MSSQL - Ektron 8.7

Related Posts

Ektron Alias With Folder Name

Posted on

With assistance from my Ektron Content Folder Names script this script will display all aliases with the folder that the content belongs to. This is not an ideal process as you can have many folders in Ektron but this can help. SET NOCOUNT ON DECLARE @Domain VARCHAR(50) SET @Domain =…

Read More

List Views In Database

Posted on

SELECT name FROM sys.views ORDER BY name SET NOCOUNT ON DECLARE @ViewName AS nVarChar(128) , @Query AS nVarChar(500) /* Declare Cursor */ DECLARE Cur_Views CURSOR FOR SELECT name FROM [sys].[all_views] x WHERE x.schema_id = 1 — Loop through the views. OPEN Cur_Views — Fetch the first view FETCH NEXT FROM…

Read More

Windows Server – Enable TLS 1.2 Support

Posted on

Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2] [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client] "DisabledByDefault"=dword:00000000 "Enabled"=dword:00000001 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server] "DisabledByDefault"=dword:00000000 "Enabled"=dword:00000001 All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what…

Read More