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.
Category: MSSQL – Ektron
This area of the site is dedicated to Ektron CMS specific MS SQL queries and procedures.
Clean Up Database
CAUTION: This is a very powerful script, use at your own risk! This script will: Drop all non-system stored procs Drop all views Drop all functions Drop all Foreign Key constraints Drop all Primary Key constraints Drop all tables
Ektron – Find DMS Content File
Sometimes you’re asked where a DMS file exists on the server and have to track it down, this query should help. Caveat: It helps to know where your root/main asset directory is on your server.
Clone A Menu Into Multiple Languages
Source: http://www.codeproject.com/Articles/275767/Ektron-SQL-Script-To-Clone-A-Menu-into-Multiple-La
Ektron Current Version
This script will display the current Ektron version. Works In: 8.0.2, 8.5, and 8.7 Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Ektron Rename Templates
This script will rename template paths Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Ektron Find Replace Library Folder Names
This script will rename folder paths of renamed CMS folders. Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx