If you have more than one person in the site administration you can sometimes get duplicates, this script will help you find them.
List out all items in an Ektron menu
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.
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
Credit: fatcat1111 @ stackoverflow.com
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
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.
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