If you have more than one person in the site administration you can sometimes get duplicates, this script will help you find them.
Category: MSSQL – Ektron
This area of the site is dedicated to Ektron CMS specific MS SQL queries and procedures.
Ektron Content List
This is a collection of a few other scripts that I’ve posted here but this script concatenates widget and alias listings into one column so that you only have one row per content item.
Ektron List Widgets On Content
This is another Ektron audit script that will help list PageBuilder content items that have a widget placed on them. The script below is very similar to Ektron Alias With Folder Name
Ektron – User Access List
Similar to Ektron SQL – List All Users If you simply need a list of all of your CMS users whether they are admin or otherwise this script will help If you want to show a break down of the groups that each user is in this script will help
Ektron – Remove Content/Folder Permissions
Use EXTREME caution on this query. I recommend you do a backup of your database before you run this script as this will remove all permissions that someone has setup on Ektron.
Unlock Ektron User Account(s)
Should you ever lock out your own account and you have SQL access try this Should you ever need to unlock all accounts, not sure why, but you can try this if you have SQL access