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

C# ASPX Email File

Posted on

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <asp:label id="lblUploadStatus" runat="server"></asp:label><br /> <asp:label id="lblEmailStatus" runat="server"></asp:label><br /> <form id="form1" runat="server"> <div> From: <asp:textbox id="txtFromEmail" runat="server" /><br /> <asp:fileupload id="FileUpload1" runat="server" /><br /> <asp:button id="btnUpload" runat="server" text="Submit" onclick="btnUpload_Click"…

Read More

Ektron Rename Templates

Posted on

This script will rename template paths SET XACT_ABORT ON DECLARE @currval NVARCHAR(500) DECLARE @newval NVARCHAR(500) DECLARE @search NVARCHAR(500) DECLARE @replace NVARCHAR(500) SET @search = ‘/Index.aspx’ –string to find SET @replace = ‘/Default.aspx’ –replacement string DECLARE @pos INT DECLARE @id BIGINT BEGIN TRAN DECLARE curs CURSOR LOCAL FAST_FORWARD FOR SELECT template_id…

Read More